Jump to content

[SOLVED] using ordey by


contra10

Recommended Posts

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

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. 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.