feri_soft Posted November 3, 2006 Author Share Posted November 3, 2006 By the way its form now i get an error again:[code]if(!empty($district)){ $district = join ("','", $district);$where[] = "(district IN ('$district'))";}[/code]when i view the output its not in('1','2'.....)but 1','2 ... and i get Column 'district' in where clause is ambiguousHelp please Quote Link to comment Share on other sites More sharing options...
Barand Posted November 3, 2006 Share Posted November 3, 2006 If you view $district you will get 1','2If it says district is ambiguous then you must be selecting the same column name from more than one table, maybe because you are using "SELECT * FROM). Specify which one to use eg$where[] = "(listings.district IN ('$district'))"; Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.