Jump to content

MYSQL query returning nothing


matthew798

Recommended Posts

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.

Link to comment
https://forums.phpfreaks.com/topic/232474-mysql-query-returning-nothing/
Share on other sites

Archived

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

×
×
  • Create New...

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.