List:General Discussion« Previous MessageNext Message »
From:Khan Date:October 4 2004 8:54am
Subject:MySQL Order by 2 date fields
View as plain text  
Hello,

I have two date fields (1095689105) in mysql. One is Creation date and 
other is Modify date. If news is not modified its value is 0. How can I 
sort my news so modify date is more important (if exists) than creation 
date?

TNX
Thread
• MySQL Order by 2 date fieldsKhan4 Oct
  • Re: MySQL Order by 2 date fieldsMartijn Tonies4 Oct
    • Re: MySQL Order by 2 date fieldsPaul4 Oct
      • Re: MySQL Order by 2 date fieldsEldo Skaria4 Oct
        • Re: MySQL Order by 2 date fieldsSGreen4 Oct