K, first off I'm brand new to PHP and databases.  So I
hope my question isn't stupid or unfitting to the

Welcome! Only those that don't ask are unfitting

I am creating a "search and results" page of, right
now 3 fields with more to add. 
Perhaps not necessary to my question, I have created a
working SQL statement which involved one main
transactional table and a number of joins to "static"
tables where the id codes inserted into the main table
are referenced.  All is fine.  
I thought I could use AND / OR statements, but both
don't allow for any number of fields unusued or force
a return if the first condition is met.  I have a
variable in the SQL statment , like LocationCity =
'resset1', LocationState = 'resset2', etc.

Just sure how to get the code to see if it was passed
a value or not.  Also to treat each field
independently, so if the user leaves the first 2
unchanged , and only enters the 3rd it will search for
that particular condition.  

Try this, which is assuming that you are sending variables through POST
// Start the query off right
$query = "Select * FROM table_name WHERE (";

Foreach($_POST as $key->$value) {
        if($value != '') {
                // Add the query part
                $query_frag .= " $key = '$value' AND ";

// Now you have something that looks like
// $query_frag = " first_var = 'Value1' AND second_var = 'Value2' AND
third_var = 'Value3' AND "

// Get rid of that last AND, plus close out your parentheses
$query_frag_trimmed = rtrim($query_frag,"AND ") . ')';

// Now $query_frag_trimmed = " first_var = 'Value1' AND second_var =
'Value2' AND third_var = 'Value3'"
// If you want to limit your query, tack on a limit clause on the end
$offset = 0;
$rows = 50;
$query_frag_trimmed .= " LIMIT $offset,$rows";

// Now put it all together
$completed_query = $query . $query_frag_trimmed;

// You've got:
// $completed_query = "Select * FROM table_name WHERE ( first_var =
'Value1' AND second_var = 'Value2' AND third_var = 'Value3') LIMIT

// And send that to mysql

Also I should mention, that when the Search form comes
up, all the drop down menus say "Please Select", that
label actually has a value, which I assume is common. 
Regardless on "submit" that value is going.   

I was looking at the following code but the !='' tells
me that it's looking for an empty string.  So if my
dead "Please Select" value is sent , do I need to put
the value in there, i.e. !='XXX' ?

if (isset($HTTP_GET_VARS['states']) && $HTTP_GET_VARS['states']!=''){
  if (!isset($isNotFirst) OR $isNotFirst==false){
       $isNotfirst = true;
       $KT_search = '1=1 AND ';
       $KT_search .=' AND ';
  $KT_search .='LocationState = \''.$HTTP_GET_VARS['states'].'\' '; } ?>

Well I hope I don't get flamed since I'm obviously
clueless and seeking some advice when perhaps I should
be finding it on my own. 

Thank you ,

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to