Looking for help with a query in php script

[NETSYNC]

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!

[BlueSkyIS]

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.

[NETSYNC]

Oh ok so if I add an if statement before the query I can check for null and error, else run query.

 

Thanks!