Member Avatar for rcasinillo_s

Good day to all members!

Please help me :cry:

Anybody could help me or could give me a php code.
What I need is I want to put link on each data that I had retrieved through array from mySQL database so that when I'm going to click each of them it will display their additional information. I had tried, but I got always the data in the last row of the table. To be more vivid here is my code:

Table information.
roland-table name
fields
1. name
2. fname
3. email
4. address
5. age
6. b-day
7. tel
8. mobile

code:
$query = "SELECT * FROM roland";
$result = mysql_query($query, $link);

while ($rs = mysql_fetch_array($result)){
//I want to print only these two fields (name, fname)
$name = $rs;
$fname = $rs;
print("Name: $name $fname");
}

//Output:
Name: Haydee Roy
Name: Rolando Casinillo
Name: Ricky Santos

Now, the output I want to be like these:

Name: Haydee Roy
Name: Rolando Casinillo
Name: Ricky Santos

So that when I'm going to click each of them I will get or display their additional informations.

Any codes relevant to above mentioned you can give are big help for me and I will highly appriated.

More power to this site!

Thank very much in advance....

Roland

  • 2 Contributors
  • 1 Reply
  • 134 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by calcop
Member Avatar for calcop

I don't think I understand what you want. So, I think you want to be able to click on a name and go to a page that has more information? Is that correct? If so, just make a hypertext link for each name that takes the user to a different document that pulls up the more detalied information.

Does this help?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.