Reece wrote: I started

JeevesBond — Fri, 11 Jan 2008 20:45:54 +0000

Reece wrote: I started building www.pcgeniusproductions.com with that cms, but found I could do better things manually, so I stick to good old direct PHP/HTML coding.

Makes sense, particularly if you're learning PHP, nothing like learning an extra API to add confusion.

Reece wrote: Give my compliments to Megan, and as you're already here, Special thanks to JeevesBond for producing an excellent service.

No worries, I'll pass that on. Thanks.

Oh, right, yes you are

Reece S — Fri, 11 Jan 2008 20:35:00 +0000

Oh, right, yes you are right, I will be needing to order them, very soon actually. I have it set to VARCHAR, I will set it to TIMESTAMP. Thanks for your advice.

Glad to see you fixed drupal, I started building www.pcgeniusproductions.com with that cms, but found I could do better things manually, so I stick to good old direct PHP/HTML coding.
I will probably be using Drupal for my education section. Probaby for the webmaster resources and things like that. Things that don't require much templating.

Thanks again, and good luck with future ideas. Give my compliments to Megan, and as you're already here, Special thanks to JeevesBond for producing an excellent service.

Also, if you use the correct

JeevesBond — Fri, 11 Jan 2008 15:17:27 +0000

Also, if you use the correct date format in MySQL it'll make indexing easier. You'll probably want to ORDER BY that field at some point.

I would like to suggest, if

mscreashuns — Fri, 11 Jan 2008 01:06:33 +0000

I would like to suggest, if maybe even just for the future...

If you aren't already, I would suggest that the DATE column is set as one of the DATETIME, TIMESTAMP, etc field types so you can format them upon selecting them from the table. This way you are not stuck with the format that was entered when the data was inserted, but you still have all the data for the timestamp. How much sense doesn't that make?

Never mind... I sorted it

Reece S — Thu, 10 Jan 2008 23:40:30 +0000

Never mind... I sorted it with this:

<?php
$date=mysql_real_escape_string(date(\"F j, Y\")); 
?>

then just added it to the list of values to insert into the database:
mysql_query("INSERT INTO `users` VALUES ('$fname', '$lname', '$email', '$username', '$password', '$date')");

Hope this helps anyone having the same problem.

PS< how come, I have had this problem for days, and now I have posted, I sort it??? Wierd huh?