Accessing Relational Data...
Posted: Mon Jan 13, 2003 5:02 pm
Hi all,
I am not very good with DB stuff so I am wondering what happens if you have relational data in another table...Meaning, I have a table that contains information for parents:
And another containing information for kids:
What I am wondering is if I relate p_login[kid*] to k_main[ID] will it create a 2 dimesional array for accessing the childs data? I mean, will I be able to access kid1's pet name, after querying the DB and fetching the p_login array, by using something like $row['kid1']['petp0']?
If not, could someone please explain how to access the childs data without having to do a second query if possible? Thanks!
I am not very good with DB stuff so I am wondering what happens if you have relational data in another table...Meaning, I have a table that contains information for parents:
Code: Select all
CREATE TABLE p_login (
ID bigint(20) NOT NULL auto_increment,
rname varchar(25) NOT NULL default '',
email varchar(100) NOT NULL default '',
u_name varchar(25) NOT NULL default '',
u_pass varchar(32) NOT NULL default '',
kid0 bigint(20) NOT NULL default '0',
kid1 bigint(20) NOT NULL default '0',
kid2 bigint(20) NOT NULL default '0',
kid3 bigint(20) NOT NULL default '0',
kid4 bigint(20) NOT NULL default '0',
kid5 bigint(20) NOT NULL default '0',
kid6 bigint(20) NOT NULL default '0',
kid7 bigint(20) NOT NULL default '0',
kid8 bigint(20) NOT NULL default '0',
kid9 bigint(20) NOT NULL default '0',
u_level tinyint(4) NOT NULL default '0',
PRIMARY KEY (ID),
UNIQUE KEY u_name (u_name),
UNIQUE KEY kid0 (kid0),
UNIQUE KEY kid1 (kid1),
UNIQUE KEY kid2 (kid2),
UNIQUE KEY kid3 (kid3),
UNIQUE KEY kid4 (kid4),
UNIQUE KEY kid5 (kid5),
UNIQUE KEY kid6 (kid6),
UNIQUE KEY kid7 (kid7),
UNIQUE KEY kid8 (kid8),
UNIQUE KEY kid9 (kid9),
UNIQUE KEY ID_2 (ID),
KEY ID (ID)
) TYPE=MyISAM;Code: Select all
CREATE TABLE k_main (
ID bigint(20) NOT NULL auto_increment,
u_name varchar(25) NOT NULL default '',
u_pass varchar(25) NOT NULL default '',
u_level tinyint(4) NOT NULL default '0',
rl_name varchar(50) NOT NULL default '',
email varchar(50) NOT NULL default '',
p_email varchar(50) NOT NULL default '',
p_id bigint(20) NOT NULL default '0',
t_email varchar(50) NOT NULL default '',
t_id bigint(20) NOT NULL default '0',
home_school tinyint(4) NOT NULL default '0',
pet0 bigint(20) NOT NULL default '0',
pet1 bigint(20) NOT NULL default '0',
pet2 bigint(20) NOT NULL default '0',
pet3 bigint(20) NOT NULL default '0',
pet4 bigint(20) NOT NULL default '0',
sh_addr bigint(20) NOT NULL default '0',
sw_addr bigint(20) NOT NULL default '0',
sch_approved tinyint(4) NOT NULL default '0',
vbucks bigint(20) NOT NULL default '0',
PRIMARY KEY (ID),
KEY ID (ID),
UNIQUE KEY ID_2 (ID),
UNIQUE KEY u_name (u_name),
UNIQUE KEY email (email)
) TYPE=MyISAM COMMENT='Childrens Login and main data is stored here.';If not, could someone please explain how to access the childs data without having to do a second query if possible? Thanks!