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? Quote 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. Quote 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! Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.