NETSYNC Posted October 4, 2010 Share Posted October 4, 2010 Hey all I am almost done with my custom script and need one thing. Here is my code: $con = mysql_connect(DB", "XXXX", "XXXX"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("XXXXXXX", $con); $name = $_POST['name']; $result = mysql_query("SELECT * FROM track WHERE name LIKE '%$name%'"); $num_rows = mysql_num_rows($result); while($row = mysql_fetch_array($result)) { echo $row['id']; echo $row['name']; echo $row['phone']; } ?> The above works good but currently if the user submits the form empty it still pulls all the names in the database due to the "like" use. I need to use like in this way because I need to be able to search partial names. How can I make it stay the exact same but ignore the query results if its NULL or empty? Thanks! Quote Link to comment Share on other sites More sharing options...
BlueSkyIS Posted October 4, 2010 Share Posted October 4, 2010 check that the value isn't null or empty before you execute the query. if empty or null, display an error instead of performing the query. Quote Link to comment Share on other sites More sharing options...
NETSYNC Posted October 4, 2010 Author Share Posted October 4, 2010 Oh ok so if I add an if statement before the query I can check for null and error, else run query. Thanks! Quote Link to comment 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.