i have a log in script is working and everything..but i want to add the date that the account was created so it can be store in my data.. can any one help
@PineSolPirateJan 04.2007 — #Add a field in your DB for it, then when they make the account do a [B]time()[/B] and stash it in there with your query. Later you can use [B]date()[/B] to get the formatting you want on it.
@NightShift58Jan 04.2007 — #An alternative would be to define a [b]date[/b] field (format will be: YYYY-MM-DD) in your table and, when you insert the user, including that field in the field and values list, using the MySQL function [b]NOW()[/b] as a value for the field.
Later, when you retrieve, you can use MySQL's [b]DATE_FORMAT()[/b] to get whatever format you need.
@PineSolPirateJan 04.2007 — #Good point NightShift. I need to learn my DB stuff, it's always been just a simpleton thing to me, push data in drag it out. I bet if I did life would get easier. ? Plus I imagine doing things in MySQL would be faster since it's compiled (obviously) ?
@NightShift58Jan 04.2007 — #That would be a little bit off-topic, but I would say not to assume that compiled is faster.
I just had a case where using a set of built-in, compiled and optimized PHP functions was between 10 and 30 times slower than running two loops, depending on data complexity.