Re: [PHP] creating a SELECT AND query

2006-04-18 Thread Richard Lynch
On Tue, April 18, 2006 6:03 am, Ross wrote: > select name="area" class="text" id="area"> > All of Scotland > Aberdeen City Counci... > > > > This is what I thought would work.. > > > $query1= "select * from $table_name WHERE sname LIKE '$searc

Re: [PHP] creating a SELECT AND query

2006-04-18 Thread Robin Vickery
On 18/04/06, Ross <[EMAIL PROTECTED]> wrote: > > $query1= "select * from $table_name WHERE sname LIKE '$search_string%' "; > > if ($area="a") { > $query1 .=" AND area='a'"; > } > else { > $query1 .="AND area='$area'"; > } Firstly, you're assigning "a" to area rather than testing whether $ar

[PHP] creating a SELECT AND query

2006-04-18 Thread Ross
I have a textboxt which searches for the surname of a client. A SELECTBOX searches for the area. I am trying to generate a query that searches all of scotland (when area=a) and by area (say I live in area 16= "edinburgh") and combine this with the name search select name="area" class="text" i