Sorting with 2 fields ??

[habbardone]

I am currently sorting my db output using the following code:

$sql = "SELECT * FROM homes
WHERE feature = 'a ' ORDER BY $sorter

The varable $sorter contains the desired field name .

I want to also sort according the DATETIME field that is in each record and is called create_date.

Does anyone know how do I do a double sort ?
i.e. first by the chosen field and then in date order ?

Thanks
david

[laserlight]

Just:
ORDER BY column1, column2