Dear List -
I know I have a mistake here, but I cannot find it.
This is a part of a switch.
The switch is fed with a formatted phone number [123-456-7890], which is
then tested for validity, and if valid the results of the query are
displayed. I cannot get to the display part.
Here is the code:
case 'step28':
{
echo "here we are, step 28";
$phn = $_POST['phone'];
$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];
$sql1 ="select Cust_Num, Lname, Fname from Customers where
Phone = '$Phn' ";
echo $sql1;
$result1 = mysqli_query($cxn, $sql1);
echo 'here2';
if ( 0 === $result1->num_rows )
{
?>
<div align="center">
<strong>No Match Found</strong>
<br /><br />
</div>
<?php
}
echo 'here3'; //stops at this point .................
echo "<br />result..... $result1";
print_r($result1);
$result = 0;
?>
<div align="center">
<table border="4" cellpadding="5" cellspacing="55" rules="all"
frame="box">
<tr class='heading'>
<th>Last Name</th>
<th>First Name</th>
<?php
while($row1 = mysqli_fetch_row($result1))
{
$Cust_Num = $row1[0];
$Lname = $row1[1];
$Fname = $row1[2];
?>
<tr>
<td> <?php echo $Cust_Num; ?> </td>
<td> <?php echo $Lname; ?> </td>
<td> <?php echo $Fname; ?> </td>
</tr>
<?php
}
?>
</table>
</div>
<?php
break;
}
TIA
Ethan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php