order by
Hey Ray
How would I modify the following recordset to order by a specific record from a specific column so that it shows at the top and then the rest of the results are then shown after that alphabetically?
<?php
$Downloads = new WA_MySQLi_RS("Downloads",$DBConnection,0);
$Downloads->setQuery("SELECT * FROM productmanufacturers WHERE Live = 1 ORDER BY ManufacturerName ASC");
$Downloads->execute();?>
cheers
Jamie