Advanced PHP search function

[phpforfun]

Hey guys, so im working on my website, and so far, its the hardest one ive done... I have done many search functions, but mostly just key words or something like that.

take a look at this page..

Analyze That Host

I wanted to make it so if you select "picky" on the development or management form, it will not search the SQL database for webmasters who have any of those settings, but if you select picky, thats where I get kinda stuck.

Here is my code so far.

PHP Code:

    if(isset($subaction)) { 

        if($subaction === "submit"){

            if(empty($development)){
                $development = "no";
            }
            if($development === "yes"){
                if(isset($PHP)){    
                    //do this
                }
                if(isset($ASP)){    
                    //do this
                }
                if(isset($flash)){    
                    //do this
                }
                if(isset($java)){    
                    //do this
                }
            } Else {
                //code for disabled development
            }
        }

    } Else {

        Echo '<div align="center"><b>Search Request Not Yet Sent</b></div>';

    } 


In place of each //do this statement, do I need to add a ton of sql code to limit that? is there a way I can just make the sql query line have like 30 where statements, so it keeps limiting down the search output? Thanks guys.

[Xav]

How many times are you going to flash that site around, dude? It's practically my HOMEPAGE!

Sorry, don't know much PHP.

[phpforfun]

Originally Posted by Xav

How many times are you going to flash that site around, dude? It's practically my HOMEPAGE!

Sorry, don't know much PHP.

im not trying to flash it around, I just need some help. The other thread was more for ideas. If I was flashing it around, id make a thread saying the status of it.

[Xav]

Ok. You're forgiven.

[phpforfun]

has anyone done this kind of search before?

I just need help modifying the query with each variable like if $notpicky is checked, how do I make it not add the 10 variables to the query?

[John]

I really don't understand the whole idea behind "Picky" and "Not Picky" which is why I have not responded.

[phpforfun]

picky means there picky about management / development, not picky means I want the code to not even look at the development or management sections in the sql db...


lets say they select "picky", I want the sql query to select WHERE PHP='yes'... if they select not picky, I dont want it to add any of the management or development variables or anything in the sql query.

basicly, without having 1000 sql query commands, how do I use eac line to add an sql query...

PHP Code:

  if(isset($subaction)) { 

        if($subaction === "submit"){

            if(empty($development)){
                $development = "no";
            }
            if($development === "yes"){
                if(isset($PHP)){    
                   //code to add "WHERE PHP='yes'" to the sql query
                }
                if(isset($ASP)){    
                   //code to add "WHERE ASP='yes'" to the sql query
                }
                if(isset($flash)){    
                    //code to add "WHERE flash='yes'" to the sql query
                }
                if(isset($java)){    
                    //code to add "WHERE java='yes'" to the sql query
                }
            } Else {
                //not add any of the php, java, sql, flash etc to the query.
            }
        }

    } Else {

        Echo '<div align="center"><b>Search Request Not Yet Sent</b></div>';

    } 


[John]

Unless I am still not understanding, you can do something like this:

PHP Code:

$sql = "SELECT * FROM `table` WHERE `something`='idk'";
                if(isset($PHP)){    
                   $sql .= " AND `PHP`='yes'";
                }
                if(isset($ASP)){    
                   $sql .= " AND `ASP`='yes'";
                }
                if(isset($flash)){    
                    //code to add "WHERE flash='yes'" to the sql query
                }
                if(isset($java)){    
                    //code to add "WHERE java='yes'" to the sql query
                } 

$result = mysql_query($sql); 


[phpforfun]

Originally Posted by John

Unless I am still not understanding, you can do something like this:

PHP Code:

$sql = "SELECT * FROM `table` WHERE `something`='idk'";
                if(isset($PHP)){    
                   $sql .= " AND `PHP`='yes'";
                }
                if(isset($ASP)){    
                   $sql .= " AND `ASP`='yes'";
                }
                if(isset($flash)){    
                    //code to add "WHERE flash='yes'" to the sql query
                }
                if(isset($java)){    
                    //code to add "WHERE java='yes'" to the sql query
                } 

$result = mysql_query($sql); 


Ill try that, thanks john

[phpforfun]

That works great! Thanks!..

how do I do less than or greater than statements in SQL? WHERE lowestprice<'2' ?