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 > 000101c227fb$74eed940$68ed0dd1@gateway">news:000101c227fb$74eed940$68ed0dd1@gateway... > Hi all. > > I'm 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 col2 = value2 AND col3 > = % > > % goes for an unselected select box (default value = %) in case the user > doesn't want to make an *advanced* search, so it fetches all rows which > does contains values 1 & 2. > > Thanks, > > <mailto:[EMAIL PROTECTED]> Cesar Aracena > CE / MCSE+I > Neuquen, Argentina > +54.299.6356688 > +54.299.4466621 > > > > > > -- > 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
