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 Link to comment https://forums.phpfreaks.com/topic/24585-how-to-make-a-search-with-many-options/page/2/#findComment-119120 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'))"; Link to comment https://forums.phpfreaks.com/topic/24585-how-to-make-a-search-with-many-options/page/2/#findComment-119165 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.