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

Reply via email to