Im trying to figure out how to do a search trough a MySQL db using LIKE
or = but the thing is that I have 3 select boxes from where to choose
the search terms. Can I use something like a wildcard instead of making
several IF statements like this?
SELECT * FROM table_name WHERE col1 = value1 AND
Shit.
Doesn't really make sense
Sorry... I probably don't understand
do you have an online example.
César aracena [EMAIL PROTECTED] wrote in message
000101c227fb$74eed940$68ed0dd1@gateway">news:000101c227fb$74eed940$68ed0dd1@gateway...
Hi all.
I'm trying to figure out how to do a search
why put in your query you want to look for an value .. if they don't want to
look for it ?..
vins writes:
Shit.
Doesn't really make sense
Sorry... I probably don't understand
do you have an online example.
César aracena [EMAIL PROTECTED] wrote in message
PROTECTED]]
Sent: Wednesday, July 10, 2002 7:27 AM
To: [EMAIL PROTECTED]
Subject: [PHP] Re: Wildcard
why put in your query you want to look for an value .. if they don't
want
to
look for it ?..
vins writes:
Shit.
Doesn't really make sense
Sorry... I probably don't understand
Andersson
-Original Message-
From: César Aracena [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 12:50 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: [PHP] Re: Wildcard
Ok. Maybe I didn't express myself well (must be the 3-4 days awake ;)
No, I don't have
[mailto:[EMAIL PROTECTED]]
Sent: 10 July 2002 11:50
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: [PHP] Re: Wildcard
Ok. Maybe I didn't express myself well (must be the 3-4 days awake ;)
No, I don't have an example on-line 'couse this is something I'll start
doing in a few days or hours
10, 2002 8:06 AM
To: 'César Aracena'
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP] Re: Wildcard
Theres no point selecting on a value if they've not specified one. The
following code should generate a valid query, assumin that the default
value for each value select value is an empty string
7 matches
Mail list logo