Drop Down List values

From: Ronan (ronanmckeon_at_campus.ie)
Date: 07/28/04 

Date: 28 Jul 2004 02:49:15 -0700

I am building a db, using mysql and php. Having called values from a
table I reproducing them in a drop down listbox on a web interface
using php. Once the user selects a value from the drop down list, i
want to select a cost from another table based on that selection. Here
is part of the code:

$resultDest = mysql_query("SELECT dest_city FROM dest_point", $db);
if(mysql_num_rows($resultDest))
{
echo" <td width=195 height=41 form name=formDestPoint method=post>";
echo"Destination Point&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp";
echo"<select name=listDestPoint>";
        while($row = mysql_fetch_row($resultDest))
        {
         print("<option =\"$row[0]\">$row[0]</option>");
        }
echo"</select></td>";
}
else
{
print("<option value=\"\">No cities created yet</option>");
}

So based on the value selected from this list box, and another list
box, a cost button is clicked, and i basically lines up the cost with
the various values selected. As I said I am a novice so any help would
be great,

Cheers
Ronan

Quantcast