|
|
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.
Navigation:
[Reply to this message]
|