PHP / ODBC >>> SQL / Drop Downs

[scisuk]

Hi everyone,

I have an sql table called "category".
In this table there is one column called "module".

I CAN connect to this table - MySQL is not an option so I am connecting using the PHP built in ODBC facilities. This is not a problem.

What I would like to do is pull every row of data out of the category table and place it into a dropdown box on a php page so that the users can select which module they would like.

If anyone could help I would be most grateful.

Thanks,

Simon

[mystrymaster]

Check the php manual - I don't know the command of the top of my head but there is a built in php mysql command to get the names of the tables

[Cynthia_Blue]

I just did something similar... here's my code, though I use a sybase database there are corresponding functions for ODBC I'm sure. (If I understand what you mean)

$SQLS="SELECT System FROM SYSTEM ORDER BY System ASC";
$list = sybase_query($SQLS, $linkID); 
while ($rows = sybase_fetch_array($list)) 
{ 
  echo "<option value='", $rows[System], "'>", $rows[System], "</option>"; 
} 

Course you gotta put the form tag and select tag around it too. 🙂

[scisuk]

Thank you for your help.

I am not back in the office until Tuesday now so will not have the opportunity to try this until then.

I will let you know how I get on.

Simon