Loop not working like i think it should

[matthew798]

Yeah thats right! I think it should work my way!

 

include '../dbconnect_form_fields.php';
$res = mysql_query("SELECT * FROM form_fields") or die(mysql_error());

while($res = mysql_fetch_assoc( $res )){ 
     echo "<option value='".$res['id']."' > ".$res['field']." ".$res['price']."</option>\n";
}

 

Why is this only returning the first row of the values in my DB? Why wont it display the second one as well?(as there are only 2)

 

Thnx champs!

[PFMaBiSmAd]

The following are the most likely causes (from most to least likely) -

 

1) That's not the whole actual code and you either have -

    1a) a line of code, between where you execute the query and where you start the loop, that is fetching and discarding a row, or

    1b) some code in the while() loop that is overwriting the result resource so that it doesn't exist the second time through the loop,

 

2) You actually only have one matching row in your database table, or

 

3) That's not the actual query that is producing the result resource that your loop is using, or

 

4) Something in your data looks like HTML and is breaking the HTML and the other row of data might be visible in the 'view source' of the page in your browser.

[kickstart]

Hi

 

You are over writing the queries results set with the first results:-

 

while($res = mysql_fetch_assoc( $res ))

 

Change one of them to a different variable name (and other lines that refer to the one you change).

 

All the best

 

Keith

[PFMaBiSmAd]

LOL - 1b

[matthew798]

i know about that i just forgot to mention it. I had tried that as a last ditch attempt to eliminate me being retarded and i guesse in doing it I only proved that i am ..