my users are going to be given the option of messaging other users... these small message will be stored in the database and be timestamped.
i was just curious what field i should make the timestamp so i could order the messages in the order they came (over multiple days)
should i use the DATETIME field, or TIMESTAMP or what?
do functions exist that would return the entries in the right order? do i have to set these fields or does mySQL do that automatically? if I did an ORDER BY in the query would it return the rows in the order i want?
thanks in advance for letting me be lazy and not get the manual out...
i was just curious what field i should make the timestamp so i could order the messages in the order they came (over multiple days)
should i use the DATETIME field, or TIMESTAMP or what?
do functions exist that would return the entries in the right order? do i have to set these fields or does mySQL do that automatically? if I did an ORDER BY in the query would it return the rows in the order i want?
thanks in advance for letting me be lazy and not get the manual out...