>You can see my problem here.  I want to be able to write parts of my sql
statement based upon >user input, and then execute it all at once.  How do I
tie all of my $qual variables in so >that this will read/execute it
properly?

$where = ' where 1=1 ';
if ($dig == '1'){
    $where .= " and track >= 0 ";
}
elseif ($dig == '2'){
    $where .= " and track >= 0 ";
    $where .= " and track <= 100 ";
}
if ($lot == '1'){
    $where .= " and acres >= 100 ";
}
elseif ($lot == '2'){
    $where .= " and acres >= 500 ";
    $where .= " and acres <= 650 ";
}


--
Visit the Zend Store at http://www.zend.com/store/
Wanna help me out?  Like Music?  Buy a CD: http://l-i-e.com/artists.htm
Volunteer a little time: http://chatmusic.com/volunteer.htm




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to