skyer2000 Posted March 15, 2007 Share Posted March 15, 2007 So many questions today, I promise this is my last one! I'm stumped on something and can't find out how to solve this. Here is the breakdown I have a form that is posting to another page, and on that other page the posted elements fill out a MySQL where statement. It is posting school, state, and category. When each field has a value in it, it works fine. However, the default value of "All Schools" or "All States" or "All Categories" will not work. I've tried using a * and also an %. I've also just left the fields at value="", but after post, it considers that a value even if i'm using isset to check it. Any ideas on how to solve this? Link to comment https://forums.phpfreaks.com/topic/42796-solved-form-post-to-mysql-where/ Share on other sites More sharing options...
HaLo2FrEeEk Posted March 15, 2007 Share Posted March 15, 2007 $allschools = $_POST['allschools']; if(isset($allschools)) { if($allschools == "") { $allschools = "*"; } } This should return a * into your WHERE in your query is allschools is left blank, if you need any help, just ask me. Link to comment https://forums.phpfreaks.com/topic/42796-solved-form-post-to-mysql-where/#findComment-207728 Share on other sites More sharing options...
skyer2000 Posted March 15, 2007 Author Share Posted March 15, 2007 Worked like a charm. Thanks! Link to comment https://forums.phpfreaks.com/topic/42796-solved-form-post-to-mysql-where/#findComment-207733 Share on other sites More sharing options...
HaLo2FrEeEk Posted March 15, 2007 Share Posted March 15, 2007 No problem, glad I could help. Link to comment https://forums.phpfreaks.com/topic/42796-solved-form-post-to-mysql-where/#findComment-207735 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.