Drop Down Help

[Dillenger]

Can anyone tell me what i'm doing wrong here?

      <select name="delete" class="formtex">
        <option>-- select a gallery --</option>
<? 
require('config.inc');
// connect to database
$cid = mysql_connect($host,$usr,$passwd);
$select_db = mysql_select_db("simplebit_com",$db); 

$sql = "SELECT dir, dir_url FROM gallery_dir";

$result = mysql_query($sql,$db); 

while ($directory = mysql_fetch_array($result)) { 

  $dir = $directory['dir']; 
  $dir_url  = $directory['dir_url'];

  echo "<option value=\"$dir_url\">$dir</option>\n"; 

} 

?> 	  

	  </select>

I get 3 errors:
<b>Warning</b>: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in <b>/home/dhill/simplebit-www/dillenger/display.php</b> on line <b>137</b><br />
<br />
<b>Warning</b>: mysql_query(): supplied argument is not a valid MySQL-Link resource in <b>/home/dhill/simplebit-www/dillenger/display.php</b> on line <b>142</b><br />
<br />
<b>Warning</b>: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/home/dhill/simplebit-www/dillenger/display.php</b> on line <b>144</b><br />

[planetsim]

$select_db = mysql_select_db("simplebit_com",$db);
you are using 2db's is what mysql thinks.. take one of them out. You dont need them..

Then the rest of your errors, you dont actualy need the $db in the rest of the statements.

Then it should work

[Dillenger]

Thanks 🙂

that works well