Jump to content

[SOLVED] First time using 2 tables,


sanderphp

Recommended Posts

I am creating my first db with 2 tables. I am tracking how many miles my friends and I are riding. 

 

 

My first table is "riders" and has these fields:

 

'ID'  int  autoincrement primary

'rider'  Text

 

Second table is "info" and has these fields"

 

'ID'  int  autoincrement primary

'date' date

'total_distance' int

'total_time' int

'rider_id' int

 

Can anyone point me in the right direction on how I would my data to 2 tables, I've only done simple single table db's before.

 

Link to comment
https://forums.phpfreaks.com/topic/103810-solved-first-time-using-2-tables/
Share on other sites

On how you would create them or how you would insert your data into them?

 

If you have phpmyadmin, you can easily go into the db to create the tables.

 

But if you don't, then use this guide. 

 

http://www.tizag.com/mysqlTutorial/mysqltables.php

 

Post back on what you were needing help on.

Sorry I should have read my post before hitting Post.  I need help understanding how I store the data.  I would manually add records to the first table to enable users right?  Then the riders would log their miles based on them choosing their own name from a picklist or based on their log in to the page. Does that sound like the way I need to do this?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.