SELECT statements and AND

rupertbj

I cannot for the life of me see what is wrong with this. It all works, but for where there are more than 1 record sought in the WHERE statement.

All help much appreciated!

		// below - selected by postcode or all
		if ( empty($minarea) and empty($maxarea) and $pc!="All" ) { $sql = "SELECT * FROM av WHERE postcode = '$pc' ORDER BY areasf ASC"; }
		elseif ( empty($minarea) and empty($maxarea) and $pc="All" ) { $sql = "SELECT * FROM av ORDER BY areasf ASC"; }
		// below - selected by maxarea
		elseif ( $pc="All" and empty($minarea) and !empty($maxarea) ) { $sql = "SELECT * FROM av WHERE areasf <= '$maxarea' ORDER BY areasf ASC"; }
		// below - selected by minarea
		elseif ( $pc="All" and empty($maxarea) and !empty($minarea) ) { $sql = "SELECT * FROM av WHERE areasf >= '$minarea' ORDER BY areasf ASC"; }
		// below - selected by postcode and maxarea
		elseif ( $pc!="All" and empty($minarea) and !empty($maxarea) ) { $sql = "SELECT * FROM av WHERE ((postcode = '$pc') AND (areasf <= '$maxarea')) ORDER BY areasf ASC"; }
		// below - selected by postcode and minarea
		elseif ( $pc!="All" and empty($maxarea) and !empty($minarea) ) { $sql = "SELECT * FROM av WHERE ((postcode = '$pc') AND (areasf >= '$minarea')) ORDER BY areasf ASC"; }
		// below - selected by postcode and maxarea and minarea
		else { $sql = "SELECT * FROM av WHERE ((postcode = '$pc') AND (areasf <= '$maxarea') AND (areasf >= '$minarea')) ORDER BY areasf ASC"; }

LordShryku

What "doesn't work"? Do you get an error message? You're last two will probably also never get evaluated to true because you set $pc="All" instead of checking $pc=="All"

rupertbj

Thanks for your response.

If you go to www.hexellwylie.com/search_av.php and try a few variations, leaving some inputs empty and using different postcodes, you will see what I mean.

The last two ask for if

$pc!="All"

not = but !=. Does this make a difference to your comment?

Many thanks in advance.

Rupert

LordShryku

It's the two before that I was referencing:

elseif ( $pc="All" and empty($minarea) and !empty($maxarea) ) { $sql = "SELECT FROM av WHERE areasf <= '$maxarea' ORDER BY areasf ASC"; }
// below - selected by minarea
elseif ( $pc="All" and empty($maxarea) and !empty($minarea) ) { $sql = "SELECT FROM av WHERE areasf >= '$minarea' ORDER BY areasf ASC"; }