Why isn't this working for searching?
// Run query on submitted values. Store results in $SESSION and redirect to
restaurants.php $sql = "SELECT name, address, inDate, inType, notes,
critical, cviolations, noncritical FROM restaurants, inspections WHERE
restaurants.name <> '' AND restaurant.ID = inspection.ID"; if ($searchName)
{ $sql .= "AND restaurants.name LIKE '%". mysql_real_escape_string($name)
."%' "; if(count($name2) == 1) { $sql .= "AND restaurants.name
LIKE '%". mysql_real_escape_string($name2[1]) ."%' "; } else {
foreach($name2 as $namePart) { $sql .= "AND restaurants.name LIKE
'%". mysql_real_escape_string($namePart) ."%' "; } } } if
($searchAddress) { $sql .= "AND restaurants.address LIKE '%".
mysql_real_escape_string($address) ."%' "; } $sql .= "ORDER BY
restaurants.name;"; $result = mysql_query($sql);
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
