Page 1 of 1

mysql/php navigation

Posted: Sun Apr 18, 2004 10:01 am
by buzzby
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.

Posted: Sun Apr 18, 2004 10:13 am
by buzzby
sorry, wrong place to post this