I am still somewhat new at this stuff, been able to modify code to my likings, but am starting to write my own script for my schedules. I am having difficulty trying to build a relationship with different tables.
MY TABLES:
CREATE TABLE f2007_divisions
(
division_id
int(5) unsigned NOT NULL auto_increment,
age
text NOT NULL,
division
text NOT NULL,
PRIMARY KEY (division_id
)
CREATE TABLE f2007_scheduling
(
club_id
smallint(3) NOT NULL default ‘0’,
status
text NOT NULL,
division_id
int(5) NOT NULL default ‘0’,
game_id
int(6) unsigned NOT NULL auto_increment,
date
date NOT NULL default ‘0000-00-00’,
notes
text NOT NULL,
time
time NOT NULL default ‘00:00:00’,
home_team
varchar(50) NOT NULL default ‘’,
h_score
text NOT NULL,
field
text NOT NULL,
field_no
text NOT NULL,
visit_team
varchar(50) NOT NULL default ‘’,
v_score
text NOT NULL,
sched_user
smallint(5) unsigned NOT NULL default ‘0’,
PRIMARY KEY (game_id
),
KEY division_id
(division_id
),
How do I build the relationship so that when I write:
[code]<?php
// mySQL Table
$division_id = $_GET[‘division_id’];
$sql = “SELECT * FROM f2007_scheduling
WHERE division=’$division_id’ ORDER BY date ASC”;
$result = mysql_query($sql) or die(mysql_error());
$i = 0;
echo "
Division: | Game ID: | Date: | True Time: | Teams: | Field: | “.$data[‘field’].” “.$data[‘field_no’].” | n"; } echo "