Hi:
I have table with provinces/states which I need to retrieve the names from.
I've been getting an error message and I just couldn't fix it!
HELP!
I get
"Supplied argument is not a valid MySQL result resource"
My code is:
<select name="ST" size="1">
<?
include_once "common.inc";
$result = mysql_query("SELECT * FROM provinces");
$query_data = mysql_fetch_row($result);
echo "<option Value=",$query_data[2]," >",$query_data[1],"</option>";
?>
</select>
As you can see I want to populate a select box with data.
Any help is greatly appreciated.
Later
Kamy
