newbie needs help with a combo box

iownslaves

Hi!

I am a bit new to php and I need some help since I can't the answer on the forum.

Here's my predicament:

When I select something from a combobox, it should take me to another page where the data of that item is printed all over the page.

So far, I am able to load the DB onto a form.
When you respond, can you print out the steps with an explanation?

Thanks!

<html>

<body>

include("db.php");

<SELECT>
<?

MYSQL_CONNECT(HOST,USER,PASS) OR DIE("Unable to connect to database");
@mysql_select_db(D😎 or die( "Unable to select database");

$query=("select * from departments order by DEPARTMENT_NAME, DEPARTMENT_NAME desc");

$result=mysql_query($query) or die ("Unable to Make the Query:" . mysql_error() );

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

echo "<OPTION VALUE=".$row['DEPARTMENT_NUMBER'].">".$row['DEPARTMENT_NAME']."</OPTION>";
}
?>
</SELECT>

</body>

</html>

gotissues68

within the form itself, use the "name" value such as:

<form>
<SELECT NAME="departments" SIZE="1">
MYSQL_CONNECT(HOST,USER,PASS) OR DIE("Unable to connect to database");
@mysql_select_db(D😎 or die( "Unable to select database");

$query=("select * from departments order by DEPARTMENT_NAME, DEPARTMENT_NAME desc");

$result=mysql_query($query) or die ("Unable to Make the Query:" . mysql_error() );

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

echo "<OPTION VALUE=".$row['DEPARTMENT_NUMBER'].">".$row['DEPARTMENT_NAME']."</OPTION>";
}
</SELECT>
</form>

then on the page this posts to you access the selected data via $_POST[departments]

HTH