[SoulieBaby]

Hey everyone..

I've got a MySQL database 'casablanca' with the following 4 tables:

- gradereports
- contactinfo
- academic
- yearlytotal

All of them have different fields, the only fields the same for all 4 is "ID", "First Name" and "Last Name". The ID is an auto number, however it's different for all - I don't know how to make the ID number the same for the same person (if that makes sense).

Anyway, this is my first database, but what I need to do is to create a table where you'd select a students name, then their information from all 4 tables will be shown.

Is that possible? And what would be the best way to go about it? (Please in lamer terms, I'm still very new to this whole PHP/MySQL thing heehee)

Any help would be greatly appreciated!

[kvnband]

OK, well, the thing is....You really don't need to have their ID, first name, and last name in each table. It would be better if you had, say, 5 tables,

information|gradereports|contactinfo|academic|year lytotal


In information, you store the user's ID, First Name, And Last Name. Then in gradereports, contactinfo, academic, yearlytotal, you have it referenced like

ID|gradereportsinfo
ID|contactinfo
ID|academic
ID|yearlytotal

I'm trying not to be confusing here, but what I'm saying is that you're making it too hard on yourself. Maybe someone else here can explain it better

Happy coding,
Kevin

[SoulieBaby]

Ahh ok cool, i'll set up another table.. sorry to sound dumb, but what would i do to reference the tables? (as i said earlier, i'm all new to this) lol

[SoulieBaby]

Anyone?

[Keith]

It's been a week, guess not.

http://www.php.net

http://www.mysql.com

Have at it.