matthew798 Posted April 2, 2011 Share Posted April 2, 2011 Hey guys! I just thought i'd let you know that your the first guys i come to when i've spent more than 20 minutes trying to fix a problem! <?php session_start(); include '../dbconnect_form_fields.php'; echo "<html><head></head><body> <form id='list' action='form_calc.php' method='post'> <select>"; $res = mysql_query("SELECT * FROM form_fields") or die(mysql_error()); while (list ($id, $field, $price) = mysql_fetch_row($res)) { echo "<option value='".$id."' > ".$field." </option>\n"; } echo "</select>"; ?> </form> </body></html> So this gives me an empty select box with only one option and no text whatsoever... What infinitesimally small detail am I unwittingly missing? Thanks in advance. Quote Link to comment https://forums.phpfreaks.com/topic/232474-mysql-query-returning-nothing/ Share on other sites More sharing options...
requinix Posted April 2, 2011 Share Posted April 2, 2011 What does echo mysql_num_rows($res); say? Quote Link to comment https://forums.phpfreaks.com/topic/232474-mysql-query-returning-nothing/#findComment-1195791 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.