mysql/php navigation

Not for 'how-to' coding questions but PHP theory instead, this forum is here for those of us who wish to learn about design aspects of programming with PHP.

Moderator: General Moderators

Post Reply
buzzby
Forum Newbie
Posts: 9
Joined: Sun Oct 12, 2003 2:13 pm

mysql/php navigation

Post 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.
buzzby
Forum Newbie
Posts: 9
Joined: Sun Oct 12, 2003 2:13 pm

Post by buzzby »

sorry, wrong place to post this
Post Reply