MySQL Database Structure |
[eluser]codedoode[/eluser]
I am planning to create a user drive application where a user signs up on on my website and a url gets created www.my-url-.com/username. The user's data will eventually be displayed using the layout on www.my-url-.com/username. My question is how do I setup my date structure. What will be the best solution for me. All help is welcome.
[eluser]geshan[/eluser]
use a timestamp like. $table['created_field'] = strtotime("now"); Make the created_field int(11) and later when you show it pass it to the php date function to format it in the way you want to.
[eluser]saidai jagan[/eluser]
In mysql create the check the current timestamp under the timestamp filed. |
Welcome Guest, Not a member yet? Register Sign In |