RE: [PHP] a quick date and session id question

Hi, All you need is to insert the data into the database as YYYYMMDD and then pull it out reformatting it with mySQL functions: SELECT DATE_FORMAT(date, "%W, %e %M %Y") AS date FROM table ; this will return you the date in "Monday, 20 April 2001" format Consult with mySQL (or other SQL DB) manuals searching for DATE_FORMAT. Sincerely, Maxim Maletsky Founder, Chief Developer PHPBeginner.com (Where PHP Begins) maxim@phpbeginner.com www.phpbeginner.com -----Original Message----- From: Sandeep Hundal [mailto:sandeep_wde@yahoo.com] Sent: Monday, April 16, 2001 11:33 AM To: php Subject: [PHP] a quick date and session id question Hi all, I got two small questions. I'm trying to make an events calendar for my site, in which I want people to input in future dates, and then have the database display events by date. NOw they will probably be given a form which allows them to choose, and then gets inputted into the datase as a number : YYYYMMDD. But I want to display the data as "Monday, 20 April 2001. How can I do this? Or should I change the way I input data?? Secondly, Anyone know fof a good tutorial explaining what sessionid's in php are for and how to use them?? TIA! /sunny ____________________________________________________________ Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net