read two fields as one in mysql table

[slyfox]

Hi

What I'm trying to do is:

Read all data from mysql table according to the dates (dd,mm,yyyy) found in the two fields (date1 and date2), the data needs to be sorted according to these dates.

Please, any ideas!!

Thank You

[solavar]

What do date1 and date2 look like?

Are they both 'dd,mm,yyyy'?
Is one of them 'dd' and the other 'mm,yyyy'?

[slyfox]

both are dd/mm/yyyy

[solavar]

As long as the data type is DATE (as opposed to varchar, or similar) try the following:



//... connection

$sql = "SELECT * FROM mytable ORDER BY date1 DESC, date2 DESC";

$result = mysql_query($sql);