I'd suggest using the following Javascript pop-up calendar! Its easy to use yet very flexible. I've used other Javascripts from this guy's site and they've worked VERY well. I highly recommend them. You can see demos of the pop-up calendar and download the code for free (he accepts donations) at http://www.mattkruse.com/javascript/calendarpopup/
Best regards, Jim at iDimensionz.com -- http://www.iDimensionz.com Professional web site design and affordable web site hosting. ------------------------------------------------------------------------ Get Firefox! <http://www.spreadfirefox.com/?q=affiliates&id=38044&t=84> – Get the new open source web browser, FireFox, and enjoy features like pop up blocking, tabbed browsing and MUCH more! Get Thunderbird! <http://www.spreadfirefox.com/?q=affiliates&id=38044&t=178> – Get the new open source e-mail client, ThunderBird, and enjoy features like integrated spam filter, privacy protection, integrated RSS reader and MUCH more! kab62uk wrote: > Hi there I am a newbie so hope you guys can help. I am developing an > admin panel for a charity who run courses for people who have been > ill and are tryin to get back into work. > > I am struggling with the dates part of it. Originally I had a > problem with getting the date to output to UK format and after much > googling, I asked a techie friend, who suggested inputting the dates > via 3 drop downs - day, month, year. > > This is fine via an html form, but I cant seem to work out the > output. > > > I can do something along the lines of: <td><?php echo > $row_Recordset1['day']; ?>/<?php echo $row_Recordset1['month']; ?>/<? > php echo $row_Recordset1['year']; ?></td> > which will give me something like 01/01/2006 > > but what I actually want is 1st January 2006 > > I thought about perhaps getting the mysql database to read the three > columns into one string in a fourth column 01012006, then setting > the output something along the lines of: > > mysql_query("select *, DATE_FORMAT(date, '%d/%m/%Y') as editeddate > from tablename"); > but how do I get it into one string in a fourth column??? > or: > is there a better way to do it?? > > I also th0ught about having a hidden field on the input form - so I > have drop downs for day, month, and year in my input form which then > add all three to the hidden field ( as a string) which then inputs > to the mysaql database - and I could use the above DATE_FORMAT to > convert to UK in the output page. > Awful stuck here any help would be very much appreciated! > Thank You The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
