Warning: mysql_fetch_assoc() expects parameter 1 to be resource ???

[etdsbastar]

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;
}

[The Little Guy]

you need to assign a variable to mysql_query, not the string.

 

Pass that to variable mysql_fetch_assoc instead.

[Pikachu2000]

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.
}