RAitch
09-16-2006, 06:11 AM
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.
$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?
On my web host, this returns an error 1064 referring to the function call DATE() for example.
$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?