WilliamC

I already told you that... number_format()

As fenway said, do not bother with formatting until after all the math you want to do is done, after that number_format() is your friend for display output.

You will likely want to do something like this: $ctr = 0; $matchcode = ''; $parts=array_map('trim',explode(' ',$keyword)); while(count($parts)>0){ $parts = array_reverse($parts); $part=array_pop($parts); $ctr++; if($ctr == 1){ $matchcode .= "`sbody` LIKE '%$part%' OR `stitle` LIKE '%$part%' OR `sdescription` LIKE '%$part%'"; } else { $matchcode .= " OR `sbody` LIKE '%$part%' OR `stitle` LIKE '%$part%' OR `sdescription` LIKE '%$part%'"; } } $sql = "SELECT `sid`, `sbody`, `stitle`, `sdescription` FROM `simple_search` WHERE " . $matchcode . " ORDER BY `stitle`";

Hello everyone, I have a unioned query that does not wish to allow ordering by field for some reason. The query itself is: (SELECT * FROM jobs_table_local WHERE (`cID`="1280" OR `scID`="1280") AND `city`="192" AND `state`="319") UNION (SELECT * FROM jobs_table_imported WHERE (`cID`="1280" OR `scID`="1280") AND `city`="192" AND `state`="319") ORDER BY Field(title, 'cna') where the 'cna' would be the keyword searched by. The intention of how this should work would be to return the results with any results where field 'title' contains the keyword 'cna' first, then all other results afterwards.