search query with several variables... ORs confusion...

v3nt

this all worked unitl i added the postcode area.
not really sure why its not working! also i only need to search the 1st 3 or 4 characters of the ppostcode field and ignore the rest. how can i do this? The ORs seem to cancel out the earlier variables requirments too! and is like very predicatable?

cheers...

 
$areax ="AND ppostcode like'BT1%' OR  ppostcode like'BT2%' OR ppostcode like'BT3%' OR ppostcode like'BT4%' OR ppostcode like'BT5%'
 OR ppostcode like'BT6%' OR ppostcode like'BT7%' OR ppostcode like'BT8%' OR ppostcode like'BT9%' OR ppostcode like'BT10%'
 OR ppostcode like'BT11%' OR ppostcode like'BT12%' OR ppostcode like'BT13%' OR ppostcode like'BT14%' OR ppostcode like'BT15%'";

$query_PD = "SELECT * FROM property WHERE pavailable ='1' AND synchDel !='1'
AND pg5<=$beds
AND pprice>$minprice AND pprice<$maxprice
AND $type  $areax 

ORDER BY $ordercrit LIMIT $thread_list_offset, $threads_per_page";

[/code]

Roger_Ramjet

v3nt wrote:
this all worked unitl i added the postcode area.
not really sure why its not working! also i only need to search the 1st 3 or 4 characters of the ppostcode field and ignore the rest. how can i do this? The ORs seem to cancel out the earlier variables requirments too! and is like very predicatable?

cheers...
 
$areax ="AND (ppostcode like'BT1%' OR  ppostcode like'BT2%' OR ppostcode like'BT3%' OR ppostcode like'BT4%' OR ppostcode like'BT5%'
 OR ppostcode like'BT6%' OR ppostcode like'BT7%' OR ppostcode like'BT8%' OR ppostcode like'BT9%' OR ppostcode like'BT10%'
 OR ppostcode like'BT11%' OR ppostcode like'BT12%' OR ppostcode like'BT13%' OR ppostcode like'BT14%' OR ppostcode like'BT15%')";

$query_PD = "SELECT * FROM property WHERE pavailable ='1' AND synchDel !='1'
AND pg5<=$beds
AND pprice>$minprice AND pprice<$maxprice
AND $type  $areax 

ORDER BY $ordercrit LIMIT $thread_list_offset, $threads_per_page";
[/code]

Just add the brackets to enforce the correct processing of the conditions.

v3nt

ah! thanks. that made a difference but because of the 'like' its bringing up results with BT23 XXX instead of just the code BT2 XXX. or BT18 XXX instead of BT1 XXX.
how can i get it to search only the characters before the space, whether its the first part of the post code has 3 or characters?

Roger_Ramjet

Leave the space in the condition "BT1 %" or "BT17 %", might work, be interesting to find out.