RE: [PHP] OK SQL experts...
| From: | Jeff McKeon | Date: | Fri, 23 Apr 2004 15:35:52 +0000 |
| Subject: | RE: [PHP] OK SQL experts... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-184409@lists.php.net to get a copy of this message | ||
> >> SELECT * FROM 'my_table' WHERE ('field_1' LIKE
> >> '%$keyword%' OR
> >> 'field_2' LIKE '%$keyword%' OR 'field_3' LIKE
> >> '%$keyword%') AND
> >> 'status' = 'active';
Longshot but try to remove the ' ' from around the field names in the
where statement..
Or
SELECT * FROM My_Table
WHERE field_1 like '%$keyword%' && status = 'active'
|| field_2 like '%$keyword%' && status = 'active'
|| field_3 like '%$keyword%' && status = 'active'
Jeff
> -----Original Message-----
> From: Brian Dunning [mailto:brian@briandunning.com]
> Sent: Friday, April 23, 2004 11:30 AM
> To: php-general@lists.php.net
> Subject: Re: [PHP] OK SQL experts...
>
>
> It gives the same error when I run it in phpmyadmin.
>
>
> On Apr 23, 2004, at 8:34 AM, Edward Peloke wrote:
>
> > does it just return the error when running in the php page? If you
> > pull it
> > out can you run it in mysql without errors?
> >
> > -----Original Message-----
> > From: Brian Dunning [mailto:brian@briandunning.com]
> > Sent: Friday, April 23, 2004 11:23 AM
> > To: php-general@lists.php.net
> > Subject: Re: [PHP] OK SQL experts...
> >
> >
> > I tried it both ways - didn't make any difference
> (phpmyadmin adds the
> > single quotes when I was trying to use its sql function to
> debug, so I
> > figured what the hell)...
> >
> >
> > On Apr 23, 2004, at 8:27 AM, Edward Peloke wrote:
> >
> >> why are the table and field names surrounded by single quotes?
> >>
> >> -----Original Message-----
> >> From: Brian Dunning [mailto:brian@briandunning.com]
> >> Sent: Friday, April 23, 2004 11:19 AM
> >> To: php-general@lists.php.net
> >> Subject: [PHP] OK SQL experts...
> >>
> >>
> >> I STFW and RTFM and I still can't figure out why this
> returns a 1064
> >> parse error:
> >>
> >> SELECT * FROM 'my_table' WHERE ('field_1' LIKE
> >> '%$keyword%' OR
> >> 'field_2' LIKE '%$keyword%' OR 'field_3' LIKE
> >> '%$keyword%') AND
> >> 'status' = 'active';
> >>
> >> Anyone? TIA!
> >>
> >> - B1ff Lamer
> >>
> >> --
> >> PHP General Mailing List (http://www.php.net/)
> >> To unsubscribe, visit: http://www.php.net/unsub.php
> >>
> >>
> >>
> > - Brian
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> - Brian
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>