I'm hoping someone can help with a hopefully simple question.
Is it possible to run a MySQL query with multiple oders statements. I'm hopeing to sort via a "Upgrade1" field and then by company name. Is this possible? I have included the basic code I have at the moment but it's only sorting via company and not both.....
mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query1="SELECT * FROM `contacts` WHERE `company` LIKE '%' AND `upgrade1` = 'Y' ORDER BY `company` ASC";
Thanks in Advance