Desperate need help!

[Richardtagger]

Hi guys i relaly urgently need help. I have a filemanagement system, I want files to be categorized.... so that i can can class files under a category or sub category..... thats ok to do with just a drop down box feeding the category into a SQL db but i need the drop down box with the list of categories to be generated according to the database. I have a table called categories... i need to be able to add categories delete but most importantly make a drop down box with a list of categories.. THANX ALOT FOR ANY HELP!

[drawmack]

google for tutorials on the subject

[Richardtagger]

dont know what to look for...

[drawmack]

mysql and php tutorial
dropdown menus

[levelwave]

$connect_id = odbc_connect("host","user","pass");

$query = "SELECT drop-down-item FROM table";

$result = odbc_exec( $connect_id, $query );

print "<select name=foo>";
while($row = odbc_fetch_array( $result ))
{
print "<option>".$row[dop-down-item];
}
print "</select>";

odbc_close( $connect_id );

[Richardtagger]

well i found and tried to use some code from php freaks.... its under a new post as im sorta stuck with it... Thanx

[levelwave]

Oops... that foreach should have been a while loop. It's corrected now.

[harman]

//change this query according to your table

function createCatDD($id){
  $sql = "SELECT field_id, field_name FORM categories";
  while($row = mysql_fetch_object(mysql_query($sql))){
     $list .= '<option value="$row->cat_id">'.$row->field_name.'</option>';
  }
}

$list = createCatDD($cat_id);

in your html>>>>>

<select name="cat_id">
<?=$list?>
</select>