contra10 Posted March 9, 2009 Share Posted March 9, 2009 hi im using the order by funtion in my query <?php $query = "SELECT * FROM `listing` WHERE `country`='$postcountry' and `continent`='$postcontinent' and `state_province` = '$poststate' and `val`= 'true' and `evcategory`='$posteva'"; if(isset($_POST['submit']) and ($_POST['continent']) and ($_POST['country']) and ($_POST['state']) and ($_POST['eva']) and ($_POST['event']) and ($_POST['city'])){$query .= " and `evcity` = '$postcity'";} $query .= "ORDER BY `dateofevsearch` DESC"; ?> this currently orders everything from least date to greater date... ie. march 3 before march 7. The problem is that i also want to order the listings not only by date but by the cost least of each day to most of each day so... March 1 $20.00, March 1 $25.00 March 2 $22.00 etc.. what it does is just organize the same date alphabetically... can i add like two order by like order by listing and cost... [/code] Link to comment https://forums.phpfreaks.com/topic/148674-solved-using-ordey-by/ Share on other sites More sharing options...
contra10 Posted March 9, 2009 Author Share Posted March 9, 2009 maybe a different approach Link to comment https://forums.phpfreaks.com/topic/148674-solved-using-ordey-by/#findComment-780722 Share on other sites More sharing options...
.josh Posted March 9, 2009 Share Posted March 9, 2009 order by column1, column2 default is ascending for both. You can specify the ascending or descending by adding on asc or desc like so: order by column1 asc, column2 asc order by column1 desc, column2 asc order by column1 desc, column2 desc order by column1 asc, column2 desc Note that it will first ordery by column1, then within that order, it orders by column2. Link to comment https://forums.phpfreaks.com/topic/148674-solved-using-ordey-by/#findComment-780730 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.