On 22 June 2014 06:00:17 BST, "Ethan Rosenberg, PhD" <erosenberg@xxxxxxxxxxxxxxxxxxxx> wrote: >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 How is it failing? When you say no error message, do you mean none displayed? It's unusual for an error not to appear in your error logs. Have you checked them? Thanks, Ash -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
