Jump to content

How do I get an $row['id'] in a drop down list


gabrielkolbe

Recommended Posts

Hi I have a query...where I loop through courses, I get the id for each course, pass it to the next page then, I want to query the database again with it, how do I do this. Will be appreciated if someone can help me. Thanks

 

<select name="course">
<?PHP
$query = "SELECT * FROM courses ORDER BY course_name"; 
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
  echo "<option id='".$row['id']."' >"; 
  echo $row['course_name']; 
  echo ' ['.$row['course_date'].'] ' ; echo ' &pound'; echo $row['course_price']; // echo the number
  echo '</option>';
}
?>
</select> 

 

Get the ID then pass it.. how do I use it again on another page and another query?

 

$query = "SELECT * FROM courses WHERE id = ???? "?
$res = mysql_query($que) or die(mysql_error());
while ($row = mysql_fetch_object($res)) { 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.