Details page from search results

[mav505]

Hey all,

I've been learning PHP for oh, about 4 days now, and I've managed to get my first MySQL Database up and running and the search function on my site working and displaying sorted results in table, so far I'm pretty proud of myself (mighty thankfull for all the tutorials here to).

But I want to extend the search function on my site so that the one of the results columns on my search results is linked through to a "Details.php" page, i.e. for the sake of example my DB has Name, Address, Telephone number, email address. I do a search on the name and the results table will show Name and Telephone number with the Name hyperlinked to a Details.php page. When the link is clicked the details page shows all the enties for that particular result i.e. Name, Tel, Address, Email.

My problem is that I have no idea where to start with this, I've seen it done on other sites but I can't find any tutorials on to teach me how to do it. I would really appreciate it if someone could point me in the right direction to do this. I can do the hyperlink in the table ok, I just don't know how to create "Details.php"

Any help would be greatly appreciated

Cheers

Paul

[[deleted]]

make sure your table has an 'id' column that lets you identify a record.
(id int auto_increment primary key not null)
In the html you print the pink to "details.php" and append this the id of the record you want to show:
href="details.php?id=$id"
Then in your details.php you just have to lookup the record that has id=$id and away you go.

[Anon]

I did this same thing with a employee database for my work. The details link just as vincent said to a ID query which returns the appropriate record.

Just be sure you have ID as a unique field.

[[deleted]]

Correct, make sure your ID column is a primary key, and set it to auto_increment. That way every newly inserted record will get a unique ID automatically, from the database engine.

[mav505]

Thx guys!!

Its working perfectly :o) Didn't realise it was that easy.

Thx for all the help
No doubt I'll be on asking more questions soon :o)

Thx again

Paul