Turned off the redirects on the whole script and tried to the the query to echo
and these are the errors I got:
Notice: Undefined offset: 1 in
/var/www/vhosts/getpublished.news-leader.com/httpdocs/ResturantInspections/processRestaurantSearch.php
on line 89
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
resource in
/var/www/vhosts/getpublished.news-leader.com/httpdocs/ResturantInspections/processRestaurantSearch.php
on line 119
On 7/21/09 11:32 AM, "Kevin Smith" <ke...@netsmith.ltd.uk> wrote:
Can you supply the actual generated SQL, I can potentially see a
problem, but need to see the final SQL statement.
Miller, Terion wrote:
> 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
