Help with PHP

[RAitch]

On my local host, a select like the following sample work fine.
On my web host, this returns an error 1064 referring to the function call DATE() for example.

PHP Code:

$query = mysql_query("select date(datetime) from pixelpost_visitors"); 


If I remove the function call, data is returned.

I don't think my web SQL is version 5 (documentation quotes versions 3 and 4) so I'm wondering if there is some kind of syntax difference. I'm having a heck of a time finding any information out there.

How can I make embedded function calls within my PHP addon code?

[RAitch]

Never mind... I figured out way to fix my problem... only took me a couple nights of head banging.