etdsbastar Posted August 24, 2011 Share Posted August 24, 2011 Please help, This code is giving me the warning stated in the above given Subject line. And combo box is also not populating. function populatecombo() { $dropdown = ""; $sqlcmb = "select wardno from wards"; mysql_query($sqlcmb) or die(mysql_error('Unable to query the table')); while($row = mysql_fetch_assoc($sqlcmb)) { $dropdown .= "\r\n<option value='{$row['wardno']}>'{$row['wardno']}</option>"; } echo $dropdown; } Quote Link to comment Share on other sites More sharing options...
The Little Guy Posted August 24, 2011 Share Posted August 24, 2011 you need to assign a variable to mysql_query, not the string. Pass that to variable mysql_fetch_assoc instead. Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted August 24, 2011 Share Posted August 24, 2011 They should both be assigned to variables. $query = "SELECT field FROM table"; if( $result = mysql_query($query) ) { while( $array = mysql_fetch_assoc($result) ) { // do whatever needs to be done. } } else { // there was an error, so handle it here. } Quote Link to comment 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.