Creating simple array from SQL results

[ViperSBT]

This shouldn't be this difficult...
[quote]$statesql = "SELECT id, state FROM state ORDER BY state";
$stateresult = mysql_query($statesql);

while ($temp = mysql_fetch_array($stateresult)){
$sid = $temp["id"];
$sst = $temp["state"];
echo "id = ".$sid."<br>state = ".$sst."<br>";
$statelist[$sid] = $sst;
}[/quote]

I have run the SELECT statement directly from the DB and get the expected return, but trying to parse it and create an array called statelist is going nowhere....  I included the echo line to see what it was doing, and I am getting a blank page...  So, it would seem to me that it isn't even performning the WHILE statement.

[zq29]

Have you tried:
[code]$stateresult = mysql_query($statesql) or die(mysql_error());[/code]

[bltesar]

Did you run the query on the same db table that your php code is accessing?  Is your server set to display errors?  The code is perfectly fine.  Either the database has not been opened properly or the query result is empty.