Posted by Dave Nash on 01/11/07 11:36

On Thu, 11 Jan 2007 12:16:22 +0100, Ruben van Engelenburg
<nospam@nospam.com> wrote:

>Dave Nash wrote:
>
>
>> Couldn't execute query: You have an error in your SQL syntax near ''
>> at line 1
>>
>> But i cant seem to find the error.
>> I tried the same sql query directly on the live db and it wors fine.
>>
>> ????
>
>Hi Dave,
>
>Same question as for the other thread: can you echo the query and post
>the exact query here?
>
>Ruben.


$query = "select * from categories WHERE parentid = $catid";
$result = mysql_query($query) or die ("Couldn't execute query: " .
mysql_error());
echo "$query";

Table is categories

CATID
PARENTID

Im trying to show all categories where the PARENTID value is the same
as the CATID value.

But it does work fine locally.

[Back to original message]