how to mysql/php page navigate?
Posted: Sun Apr 18, 2004 10:15 am
hi there. i am so stuck. i want to use a php/mysql navigation type setup. i have written the mysql code which is this:
CREATE TABLE profile (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
picture CHAR(30) NOT NULL,
PRIMARY KEY (id)
)
load data infile "c:/apache/htdocs/lojsite/database/profiletable1.txt" into table profile
fields terminated by ','
the profiletable1.txt contains lines like this:
6, /pics/pics6.jpg, text 6 text 6 text 6 text 6 text 6 text 6
(it is comma delimited)
i want to show each row as a page so in effect you get this view.php?id=23 where the 23 record that i insert into mysql is what will be shown.
i would love it if you could help me out in this.
CREATE TABLE profile (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
picture CHAR(30) NOT NULL,
PRIMARY KEY (id)
)
load data infile "c:/apache/htdocs/lojsite/database/profiletable1.txt" into table profile
fields terminated by ','
the profiletable1.txt contains lines like this:
6, /pics/pics6.jpg, text 6 text 6 text 6 text 6 text 6 text 6
(it is comma delimited)
i want to show each row as a page so in effect you get this view.php?id=23 where the 23 record that i insert into mysql is what will be shown.
i would love it if you could help me out in this.