Welcome Guest, Not a member yet? Register   Sign In
MySQL Database Structure
#1

[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.
#2

[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.
#3

[eluser]saidai jagan[/eluser]
In mysql create the check the current timestamp under the timestamp filed.




Theme © iAndrew 2016 - Forum software by © MyBB