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

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

>Dave Nash wrote:
>
>> $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.
>
>It could be that the variable $catid is empty, causing the query to be
>invalid.
>I'm not sure where $catid is being set in your script because you didn't
>post that part, hence my question to echo the $query var.
>
>Ruben.

CATID is being passed via a url

list_subs.php?catid=53

So catid should always be there.

[Back to original message]