<?php if (isset($_POST['name'])=== true && empty($_POST['name'])=== false) { require '../db/connect.php'; $query = mysql_query("SElECT id FROM Customers WHERE Customer_Name= '".mysql_real_escape_string(trim($_POST['name']))."' "); $fred = mysql_result($query,0,'id' ); echo "$fred"; $sql = "SELECT * FROM Customers WHERE id='$fred'" ; $results= mysql_query($sql); If (!$results){ die('Invalid query:'.mysql_error()); } echo "<table border=1> <tr> <th>Customer</th> <th>Region</th> <th>Email</th> <th>Phone</th> </tr>"; while($result= mysql_fetch_array($results) ){ echo"<tr>"; echo"<td>".$result['Customer_Name']."</td>"; echo"<td>".$result['Physical_Region']."</td>"; echo"<td>".$result['Email_Address']."</td>"; echo"<td>".$result['Phone_Number']."</td>"; echo"</tr>"; } echo"</table>"; } ?>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)