• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
MySQL Database Structure

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.

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.

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  

  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.