Jump to content

Archived

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

ViperSBT

Creating simple array from SQL results

Recommended Posts

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.

Share this post


Link to post
Share on other sites
Have you tried:
[code]$stateresult = mysql_query($statesql) or die(mysql_error());[/code]

Share this post


Link to post
Share on other sites
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. 

Share this post


Link to post
Share on other sites

×

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.