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; } Link to comment https://forums.phpfreaks.com/topic/245620-warning-mysql_fetch_assoc-expects-parameter-1-to-be-resource/ 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. Link to comment https://forums.phpfreaks.com/topic/245620-warning-mysql_fetch_assoc-expects-parameter-1-to-be-resource/#findComment-1261549 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. } Link to comment https://forums.phpfreaks.com/topic/245620-warning-mysql_fetch_assoc-expects-parameter-1-to-be-resource/#findComment-1261578 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.