Re: date
| From: | Russ Michell | Date: | Thu, 01 Jan 1970 00:00:00 +0000 |
| Subject: | Re: date | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-13751@lists.php.net to get a copy of this message | ||
User inserts date as a select menu for day, month and year: $day, $month, $year
You swap it around for an insert: $dateinsert = $year . $month . $day
Then query the DB: Select blah from blah where blah=blah order by datefield (Let MySQL do the rest)
Good luck!
Russ
On Fri, 26 Oct 2001 12:10:51 +0100 ax <aznym@crosswinds.net> wrote:
> how would i enter european format date into mysql (dd/mm/yyyy) ... and how
> would i make the query sort by date if i am using this format ??
>
> ax
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
#-------------------------------------------------------#
"Believe nothing - consider everything"
Russ Michell
Anglia Polytechnic University Webteam
Room 1C 'The Eastings' East Road, Cambridge
e: r.j.michell@apu.ac.uk
w: www.apu.ac.uk/webteam
www.theruss.com
#-------------------------------------------------------#