DATE_FORMAT Parse Error

.oO(Joe Makowiec)

>Yes, except pick some word other than 'date':
>
>$query = "SELECT name, DATE_FORMAT(date_received, '%m/%d/%y') AS
>myDate....
>
>'date' is frequently a keyword - it is in MySQL, and, without looking,
>probably in PHP too. Many apps don't like if you use keyword for
>something other than their intended use.

Good point, even if it doesn't matter much in this case. It works in
MySQL and PHP doesn't care at all about any reserved names in array
indexes.

Micha

On 20 Feb 2008 in macromedia.dreamweaver.appdev, WPW07 wrote:

> I think I may have resolved the problem. I needed to use
> DATE_FORMAT in the Select Statement above the table:
>
> $query = "SELECT name, DATE_FORMAT(date_received, '%m/%d/%y') AS
> date....
>
> Then in the table, use
>
> <td align="left">' . $row['date'] . '</td>

Yes, except pick some word other than 'date':

$query = "SELECT name, DATE_FORMAT(date_received, '%m/%d/%y') AS
myDate....

'date' is frequently a keyword - it is in MySQL, and, without looking,
probably in PHP too. Many apps don't like if you use keyword for
something other than their intended use.

--
Joe Makowiec
http://makowiec.net/
Email: http://makowiec.net/contact.php

.oO(WPW07)

>I think I may have resolved the problem. I needed to use DATE_FORMAT in the
>Select Statement above the table:
>
> $query = "SELECT name, DATE_FORMAT(date_received, '%m/%d/%y') AS date....
>
> Then in the table, use
>
> <td align="left">' . $row['date'] . '</td>

Correct. ;)

Micha

I think I may have resolved the problem. I needed to use DATE_FORMAT in the Select Statement above the table:

$query = "SELECT name, DATE_FORMAT(date_received, '%m/%d/%y') AS date....

Then in the table, use

<td align="left">' . $row['date'] . '</td>

William