Order by date

[7724]

Hi,

I'm trying to select data from my database to output on a php page:

SQL = "SELECT * FROM `tablename` ORDER BY date";

Now this works fine, but what I want is instead of selecting it by date, I want it to look in a variable named $dateone for all records and order it by the date there.

Now what I do not understand is how the code recognises the date? Say I have one record date as 11th January and another 12th March, surely it would not recognise to put 11th January first? Would it recognise 11/1/05 and 12/03/05 if I inputted that into my variable or not?

Hope that makes sense!

Thanks

Chris

 

[DRJ478]

PJP uses variables of specific types, such as integer, double, string, and also time (which is a full date).
When you create a date variable you can for example create a time type from a string.
Have a look at the function strtotime() and the faq434-3493 which talks about date compariosons. It will help you understand the matter better.