Posted by Ruben van Engelenburg on 01/11/07 11:57

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.

[Back to original message]