create html dropdown list from database data?

ksauls

The database table has two fields: grpno, name.
I would like to pull those two pieces of data into a dropdown selector for an html page so that the user can make a selection based on the name field, but the grpno is what gets passed for processing. This gets done in html with:

How can it be done with php?

Norman_Graham

I'm not sure what you want to do exactly, but PHP meshes very closely with HTML - that's the whole idea of PHP, or at least it was to begin with. So if you have a drop-down list with:

<option value="grpno">name</option>

... then PHP will automatically store the variable $gprno if you pass it to PHP using either POST or GET. In the current version of PHP, you can pick the variable up by using $POST(gprno) or $GET(gprno). So you can get your stuff out of the database and add it to the drop-down list and then pass it all to PHP for processing.

If this isn't what you're asking, please elaborate and I'll try again.

Norman

eomer

Ok, if I understand well, this should be what you are looking for...

<?
/ ------------------------------------------------------ /
/ connect to the DB ------------------------------------ /
/ ------------------------------------------------------ /
$db = mysql_connect("$host", "$login", "$password");
mysql_select_db("$base",$db);
/ ------------------------------------------------------- /
$sql = "select gprno, name from $table";
$req= mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());

echo '<select name="grpno">';

while($data = mysql_fetch_array($req))
{
echo '<option value='.$data['grpno'].'>'.$data['name'].'</option>';
}
echo '</select>';
mysql_close();
?>

Hope this helps... ;o)

Nicolas

ksauls

Thanks for the responses. Nicolas was right on the money that I was trying to bring data out of the database to populate my drop down list which would then pass to another page for processing. At 3am this morning while I was writing that request I'm afraid that "dakenoef hyheo n" would have made sense to me 🙂 I'm glad you understood and greatly appreciate the help.