xyla_eu
Posts: 1
|
| Posted: 07/25/2007, 1:48 PM |
|
Hi,
I use the following SQL:
SELECT *
FROM (calendar INNER JOIN training ON
calendar.training_id = training.training_id) INNER JOIN training_cities ON
calendar.city_id = training_cities.city_id
WHERE calendar.start_date > '{start_date}'
ORDER BY rand()
SQL Parameters:
Name: start_date
Type: URL
Source: start_date
Default value: (NOW)
In .NET vb this works fine. In PHP I get the following error...
The value in field urlstart_date is not valid. Use the following format: ShortDate.
I have no clue about what's going wrong
|
 |
 |
Tuong Do
|
| Posted: 07/25/2007, 4:28 PM |
|
Now() is a function in .NET
It may not a function in PHP
"xyla_eu" <xyla_eu@forum.codecharge> wrote in message
news:246a7b72183e39@news.codecharge.com...
> Hi,
>
> I use the following SQL:
>
> SELECT *
> FROM (calendar INNER JOIN training ON
> calendar.training_id = training.training_id) INNER JOIN training_cities ON
> calendar.city_id = training_cities.city_id
> WHERE calendar.start_date > '{start_date}'
> ORDER BY rand()
>
> SQL Parameters:
> Name: start_date
> Type: URL
> Source: start_date
> Default value: (NOW)
>
> In .NET vb this works fine. In PHP I get the following error...
>
> The value in field urlstart_date is not valid. Use the following format:
> ShortDate.
>
> I have no clue about what's going wrong
>
>
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 07/25/2007, 8:40 PM |
|
xyla_eu
Tuong Do is correct Now() is not a function in PHP but it is a function in MySQL.
|
|
|
|
|
