Grimloch Posted November 3, 2009 Share Posted November 3, 2009 Hello again gurus: I am getting a syntax error on this MySQL statement and can't figure out why. $result = dbquery("SELECT cid, title, description, image, parentid FROM ".DB_XXXXXXXXX." WHERE status='1' AND parentid='0' ORDER BY title LIMIT $rows"); while(list($cid, $title, $description, $image, $parentid) = dbarraynum($result)) { This is a new, empty database with table/field names only. After data is populated I do not get the syntax error. I am running MySQL 5 and PHP-5. Status is an 'enum' field that defaults to '0'. Can anyone see a syntax error here? Quote Link to comment https://forums.phpfreaks.com/topic/180163-solved-php-mysql-syntax-error/ Share on other sites More sharing options...
PFMaBiSmAd Posted November 3, 2009 Share Posted November 3, 2009 Ummm. What error? It would indicate exactly at what point something was found in the query that was out of place. Best guess is that $rows is dependent on a previous query and it does not contain what you or mysql expects. All data put into a query must be validated. Quote Link to comment https://forums.phpfreaks.com/topic/180163-solved-php-mysql-syntax-error/#findComment-950420 Share on other sites More sharing options...
Grimloch Posted November 3, 2009 Author Share Posted November 3, 2009 Yep! That was the problem... in a previous query I had 'if(dbarray($result))' rather than 'if(dbarray($result)>0)' ... Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/180163-solved-php-mysql-syntax-error/#findComment-950602 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.