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/
