gabrielkolbe Posted October 17, 2007 Share Posted October 17, 2007 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 ' £'; 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)) { Link to comment https://forums.phpfreaks.com/topic/73698-how-do-i-get-an-rowid-in-a-drop-down-list/ Share on other sites More sharing options...
marcus Posted October 17, 2007 Share Posted October 17, 2007 How is the form being processed? GET, POST, hmm? Link to comment https://forums.phpfreaks.com/topic/73698-how-do-i-get-an-rowid-in-a-drop-down-list/#findComment-371835 Share on other sites More sharing options...
gabrielkolbe Posted October 17, 2007 Author Share Posted October 17, 2007 Hi sorry, POST Link to comment https://forums.phpfreaks.com/topic/73698-how-do-i-get-an-rowid-in-a-drop-down-list/#findComment-371837 Share on other sites More sharing options...
marcus Posted October 17, 2007 Share Posted October 17, 2007 $id = mysql_real_escape_string($_POST['course']); $query = "SELECT * FROM `coursers` WHERE `id`='$id'"; # etc.. Link to comment https://forums.phpfreaks.com/topic/73698-how-do-i-get-an-rowid-in-a-drop-down-list/#findComment-371838 Share on other sites More sharing options...
gabrielkolbe Posted October 17, 2007 Author Share Posted October 17, 2007 Hi, thanks but it does not seem to work, I get the following error.. Query was empty Link to comment https://forums.phpfreaks.com/topic/73698-how-do-i-get-an-rowid-in-a-drop-down-list/#findComment-371844 Share on other sites More sharing options...
marcus Posted October 17, 2007 Share Posted October 17, 2007 $res = mysql_query($que) or die(mysql_error()); you have that... $res = mysql_query($query) or die(mysql_error()); should be that. Link to comment https://forums.phpfreaks.com/topic/73698-how-do-i-get-an-rowid-in-a-drop-down-list/#findComment-371850 Share on other sites More sharing options...
gabrielkolbe Posted October 17, 2007 Author Share Posted October 17, 2007 Thanks for pointing that out, but only get the course_name that come through not the id... Link to comment https://forums.phpfreaks.com/topic/73698-how-do-i-get-an-rowid-in-a-drop-down-list/#findComment-371867 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.