mishuk Posted February 9, 2007 Share Posted February 9, 2007 I would like to take the input from a form as the where clause in a select statement to get id number for the variable in question and post this into a database table. I have tried a few things but i can not seem to populate the $school variable with anything $schoolname = ($_POST['school']); $school = mysql_query("SELECT school_id FROM tbl_school WHERE schoolname = $schoolname); or $school = mysql_query("SELECT school_id FROM tbl_school WHERE schoolname =". $_POST['school']); Thanks Link to comment https://forums.phpfreaks.com/topic/37767-solved-select-statement-with-a-_post-variable-as-the-where-clause/ Share on other sites More sharing options...
Jessica Posted February 9, 2007 Share Posted February 9, 2007 If the name is a string, it needs to be in quotes in your sql. $schoolname = $_POST['school']; $school = mysql_query("SELECT school_id FROM tbl_school WHERE schoolname = '$schoolname'"); Link to comment https://forums.phpfreaks.com/topic/37767-solved-select-statement-with-a-_post-variable-as-the-where-clause/#findComment-180658 Share on other sites More sharing options...
mishuk Posted February 9, 2007 Author Share Posted February 9, 2007 Course yeh. Thanks Link to comment https://forums.phpfreaks.com/topic/37767-solved-select-statement-with-a-_post-variable-as-the-where-clause/#findComment-180675 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.