Re: [PHP-DB] Mysql result resource error

2001-12-19 Thread Bas Jobsen
$sql = "select Minor_Category FROM main where Page = 'wines' order by Minor_Category"; Op donderdag 20 december 2001 01:19, schreef Shannon Doyle: > Hi People, > > I am getting a Not a valid Mysql result resource error with the > following code, can someone take a look at this for me and see if

Re: [PHP-DB] Mysql result resource error

2001-12-20 Thread Jim Lucas
which one was giving you the problem? the first or second mysql try. if it was the second, try wrapping the $cattyname with single quotes like this Minor_Category = '$cattyname'. if the $cattyname var has anything but numbers, the statement won't work. Jim - Original Message - From: "S

RE: [PHP-DB] Mysql result resource error

2001-12-20 Thread Shannon Doyle
Subject: Re: [PHP-DB] Mysql result resource error > > > which one was giving you the problem? the first or second > mysql try. if it > was the second, try wrapping the $cattyname with single > quotes like this > Minor_Category = '$cattyname'. if the $cattyname