Jump to content

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


etdsbastar

Recommended Posts

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.