The problem lies in this statement: if(!$result1). Mysqli_query returns returns an object, except when the query fails. The query doesn't fail when the number of found rows is zero. So, if your query is syntactically correct, but there is no data found, $result1 is not false, but an object. Do a test for $result1->num_rows, like this: if ( 0 === $result1->num_rows ) echo "No data found". Jasper Verstuurd vanaf mijn iPad > Op 22 jun. 2014 om 07:00 heeft "Ethan Rosenberg, PhD" <erosenberg@xxxxxxxxxxxxxxxxxxxx> het volgende geschreven: > > Dear List - > > Here is a simple program. > > It ran before, but not now... > > <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> > <html xmlns="http://www.w3.org/1999/xhtml";> > > <html> > <head> > </head> > <body> > <div align="center"> > <form method="post"> > <input type='text' name=phone></input> > <input type='submit'> > <br /><br /><br /> > </form> > </div> > <?php > error_reporting(-1); > require '/home/ethan/PHP/ethan.inc'; > $db = "Store"; > $cxn = mysqli_connect($host,$user,$password,$db); > if (!$cxn) > { > die('Connect Error (' . mysqli_connect_errno() . ') ' > . mysqli_connect_error()); > } > > //if no connection no error message > > $phn = $_POST[phone]; > > //Phone is a 10 digit numerical string, no spaces > > $phn = (string)$phn; > > $dsh = '-'; > $Phn = $phn[0].$phn[1].$phn[2].$dsh.$phn[3].$phn[4].$phn[5].$dsh.$phn[6].$phn[7].$phn[8].$phn[9]; > > //construct phone number 123-466-7890 > > $sql1 ="select Lname, Fname from Customers where Phone = '$Phn' "; > > $result1 = mysqli_query($cxn, $sql1); > if(!$result1) > { > ?> > <div align="center"> > > <strong>No Match Found</strong> > <br /><br /> > </div> > <?php > } > > //if query fails, no error message. > > > //code to display query results, not listed. > > > > TIA > > Ethan > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
