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

[gabrielkolbe]

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)) { 

[marcus]

How is the form being processed? GET, POST, hmm?

[gabrielkolbe]

Hi sorry, POST

[marcus]

$id = mysql_real_escape_string($_POST['course']);
$query = "SELECT * FROM `coursers` WHERE `id`='$id'";
# etc..

[gabrielkolbe]

Hi, thanks but it does not seem to work, I get the following error..

 

Query was empty

[marcus]

$res = mysql_query($que) or die(mysql_error());

 

you have that...

 

$res = mysql_query($query) or die(mysql_error());

 

should be that.

[gabrielkolbe]

Thanks for pointing that out, but only get the course_name that come through not the id...