Edwinner

I keep getting Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at line 1. I honestly don't see where i might have gone wrong case "Update": if(isset($firstname, $lastname, $phone, $address, $city, …

$query = "SELECT * FROM customers WHERE firstname = '$firstname', lastname = '$lastname'"; $result = mysql_query($query); i keep getting Error: Query was empty

//case for database search case "Search": if(isset($firstname, $lastname)){ mysql_select_db("webuser23", $dbc); $result = "SELECT * FROM customers WHERE firstname='.$firstname.' "; mysql_query($dbc); echo "<table border='1'>"; echo "<tr>"; echo "<th>Firstname</th>"; echo "<th>Lastname</th>"; echo "<th>Phone</th>"; echo "<th>Address</th>"; echo "<th>City</th>"; echo "<th>State</th>"; echo "<th>Zip</th>"; echo "</tr>"; while($row = mysql_fetch_array($result)) { echo "<tr>"; echo "<td>" . …