suess0r Posted January 5, 2007 Share Posted January 5, 2007 hi, my array works fine but at the end i want to add 'ORDER BY orlandofull.`club name`' any ideas?? I tried putting it after the implode but i've been getting nothing but errors..[quote]$tmpq = array(); $sql= 'SELECT * FROM orlandofull WHERE '; if($city != "") $tmpq[] = 'orlandofull.Club_Landmark = "'.$city.'" '; if($type != "") $tmpq[] .= 'orlandofull.'.$typeList[$type].' = "Yes" '; if($subtype != "") $tmpq[] .= 'orlandofull.'.$subtypeList[$subtype].' = "Yes" '; if($cost != "") $tmpq[] .= 'orlandofull.`'.$cost.'` = "Yes"'; $sql .= implode(' AND ',$tmpq);[/quote] Quote Link to comment Share on other sites More sharing options...
complex05 Posted January 5, 2007 Share Posted January 5, 2007 What errors are you getting? post them please. Quote Link to comment Share on other sites More sharing options...
suess0r Posted January 5, 2007 Author Share Posted January 5, 2007 OK, at the end of the SQL statement i just want to add "ORDER BY orlandofull.`club name`" So on the implode after the $sql .= implode(' AND ',$tmpq); can i do something like $sql .= implode(' AND ', $tmpq 'ORDER BY orlandofull.`club name`'); or $sql .= (' ORDER BY orlandofull.`club name` '); 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.