Primary Key

Anon

I am a total newbie to any scripting. SO please be gentle.

I have a MySql dB using an auto increment id as my primary key.

Lets say I have an address book. I know how to use a web page to pull up everyone named John.

My question is: How do I get my search results page to convert the names of 5 people, all named John, into a seperate hyperlink for each person, then produce a results page that will show all the data for that one individual.
Thanks

Anon

In the page that shows all the data for one person you will be doing somthing like this:

$sql="SELECT * FROM address_book WHERE addres_book_id='$id'";
$results = mysql_query($sql);
$row=mysql_fetch_arra($results);

$name = $row["Name_of_Name_Field"];
$address = $row["Name_of_Address_Field"];

Where $id is the autonumber that corresponds to the given John. So since each John has a unique autonumber ID, you are just looking up the information with that ID, not his name. And of course the "Name_of_Name_Field" should be the actual name of the field that stores John's name. And "Name_of_Address_Field" would be the name of the field that actually stores the address.

Now to link to the page that shows the info about a person, you will be making an anchor that passes the $id of the person to the information display page.

echo "<A HREF='display_information_page.php?id=$row["NAME_OF_ID_FIELD"];

Basically, you just grab all the records and loop through every one printing that anchor. Every link will then be to a different person.

Hope that helps out.

AaronZoller.com

Anon

Have a look at this site, and if it's what you want to do, i can give you a copy of scripts i used !

http://membres.lycos.fr/epmiancien
(i'ts in frensh but sure you'll ...)

Anon

Thank you both for your help. I will check out your site, plus study the other scipt. I am sure between the two, I should learn something helpful.

Anon

Am I retarded or what...

echo "<A HREF='display_information_page.php?id=$row["NAME_OF_ID_FIELD"];

Should have been...

echo "<A HREF='display_information_page.php?id=" . $row["NAME_OF_ID_FIELD"] . "'>Link to " . $row["NAME_OF_NAME_FIELD"] . "</A";

Sorry.

AaronZoller.com

Anon

Thanks, I will try this combo. The earlier line
echo "<A HREF='display_information_page.php?id=$row["NAME_OF_ID_FIELD"];
gave me a parse error. I noticed that you had a double quote behind the echo and a single quote in front of display.

Anon

This line worked much better. It did give me a unique hyperlink for each result. And each link did show the id# in the address, however when I clicked on them, I got a page not found error.
I can access the results page manually, without the id number in the address, but of course it will give me an error in the php code, due to not haveing all the data supplied.
So, does that mean I have to create a seperate secondary page address with each page id# or am I doing something wrong?

Anon

I got the second page to open, but get a undefined function: mysql_fetch_arra()
error. Any ideas why?
Thanks

Anon

Thank You very much, I finally got it working. You have been a lifesaver.
Very much appreciated.

Anon

Glad I could help, even though I hadn't replied in the last 4 messages. Good job is what I should say to you. And sorry about that typo on mysql_fetch_array. I may love code, but I hate keyboards.

AaronZoller.com

mattr

Please do not enclose numeric values in single quotes. It is non-standard, shows a lack of understanding of datatypes, and only works on MySQL.