Quick implode/array help..

[suess0r]

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]

[complex05]

What errors are you getting? post them please.

[suess0r]

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` ');