Yep, sure was the spacesOMG...will I ever get it...
On 7/21/09 12:29 PM, "Ashley Sheridan" wrote:
On Tue, 2009-07-21 at 13:24 -0400, Andrew Ballard wrote:
> On Tue, Jul 21, 2009 at 1:20 PM, Miller,
> Terion wrote:
> > Here it is...I see where it's doing the restaurant.name LIKE statement 2x
On Tue, 2009-07-21 at 13:24 -0400, Andrew Ballard wrote:
> On Tue, Jul 21, 2009 at 1:20 PM, Miller,
> Terion wrote:
> > Here it is...I see where it's doing the restaurant.name LIKE statement 2x
> > which is prob messing it up right...but in the code why is it doing that
> > twice..
> >
> > SELECT
On Tue, 2009-07-21 at 12:59 -0400, Miller, Terion wrote:
>
>
> On 7/21/09 11:47 AM, "Dan Shirah" 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, in
On Tue, Jul 21, 2009 at 1:20 PM, Miller,
Terion wrote:
> Here it is...I see where it's doing the restaurant.name LIKE statement 2x
> which is prob messing it up right...but in the code why is it doing that
> twice..
>
> SELECT name, address, inDate, inType, notes, critical, cviolations,
> noncri
On Tue, 2009-07-21 at 10:07 -0700, Miller, Terion wrote:
>
>
> On 7/21/09 12:04 PM, "Ashley Sheridan" wrote:
>
> On Tue, 2009-07-21 at 12:59 -0400, Miller, Terion wrote:
> >
> >
> > On 7/21/09 11:47 AM, "Dan Shirah" wrote:
> >
> > Why isn't this working for searching?
> >
> > // Run query on
Here it is...I see where it's doing the restaurant.name LIKE statement 2x which
is prob messing it up right...but in the code why is it doing that twice..
SELECT name, address, inDate, inType, notes, critical, cviolations, noncritical
FROM restaurants, inspections WHERE restaurants.name <> '' AN
On Tue, Jul 21, 2009 at 12:41 PM, Miller, Terion <
tmil...@springfi.gannett.com> wrote:
> 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/Re
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(): supplie
On 7/21/09 12:04 PM, "Ashley Sheridan" wrote:
On Tue, 2009-07-21 at 12:59 -0400, Miller, Terion wrote:
>
>
> On 7/21/09 11:47 AM, "Dan Shirah" wrote:
>
> Why isn't this working for searching?
>
> // Run query on submitted values. Store results in $SESSION and redirect to
> restaurants.php
On 7/21/09 11:47 AM, "Dan Shirah" 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, inspe
>
> 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 <> ''
On Tue, Jul 21, 2009 at 12:26 PM, Miller,
Terion wrote:
> Why isn't this working for searching?
Check your concatenation in the query. You need some white space
padding your SQL segments, otherwise the text all starts to run
together.
(I had to reformat it. For some reason, most of the code snip
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 rest
13 matches
Mail list logo
