Hi, nice to see we're back up and running.
I have had a few problems with my sql database, (make that, with my knowledge).
Is it possible for the SQL database to automatically add the current date of when the ROW was added?
I want the date to be automatically added when the user registers. I know this is possible, as I have seen it countles times, but never actually bothered with it myself until now.
Thanks in Advance.
Reece S posted this at 23:40—10th January 2008.
He has: 163 posts
Joined: Oct 2007
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?
mscreashuns posted this at 01:06—11th January 2008.
He has: 505 posts
Joined: Jul 2005
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?
JeevesBond posted this at 15:17—11th January 2008.
He has: 3,441 posts
Joined: Jun 2002
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.
a Padded Cell our articles site!
Reece S posted this at 20:35—11th January 2008.
He has: 163 posts
Joined: Oct 2007
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.
JeevesBond posted this at 20:45—11th January 2008.
He has: 3,441 posts
Joined: Jun 2002
Makes sense, particularly if you're learning PHP, nothing like learning an extra API to add confusion.
No worries, I'll pass that on. Thanks.
a Padded Cell our articles site!