simple loop issue

[fife]

ok I have a function that querys a table for information then creates a loop for a dropdown list.  I really would like it done the way it is at the minute however its not working.  The dropdown is empty and it stops the rest of the form after the field from loading.  Error reporting brings back no errors.  Here is the code

 

//in the header 

function createoptions($table , $id , $field)
{
    $sql = "select * $table ORDER BY $field";
    $res = mysql_query($sql) or die(mysql_error());
    while ($a = mysql_fetch_assoc($res))
    echo "<option value=\"{$a[$id]}\">$a[$field]</option>";
}

 

//and the form field

<label for="networks" ></label>
      <select name="networks"  id="networks">
           <?php 
	  
	   createoptions("networks", "idnetworks", "netname");   ?> 
     
      </select>

[Pikachu2000]

I'm surprised it isn't throwing an error with no 'FROM' in the query string. Not sure why you're using variable array index $id there; it doesn't look like that's what you need.

[PFMaBiSmAd]

Because the php code is being executed inside of a html <select  ></select> tag, any mysql_error output from the code will only be in the 'view source' in your browser.