Posted by Dave Nash on 01/11/07 12:19

On 11 Jan 2007 12:12:09 GMT, Kim André Akerø
<kimandre@NOSPAMbetadome.com> wrote:

>Dave Nash wrote:
>
>> 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.
>
>Sure, if register_globals is set to "on" on both the local and live
>servers. Rather, get used to using $_GET["catid"] instead of $catid.

regsiter globals is set to 'off' on the live server.
Ive just changed it using .htaccess and it works fine now. thanks
everyone for your help.

[Back to original message]