•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 426,866 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,314 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our PHP advertiser: Lunarpages PHP Web Hosting
Views: 896 | Replies: 1
![]() |
•
•
Join Date: Jan 2006
Posts: 29
Reputation:
Rep Power: 3
Solved Threads: 0
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['name'];
$fname = $rs['fname'];
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
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['name'];
$fname = $rs['fname'];
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
•
•
Join Date: Oct 2005
Posts: 25
Reputation:
Rep Power: 4
Solved Threads: 0
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?
Does this help?
![]() |
•
•
•
•
•
•
•
•
DaniWeb PHP Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Other Threads in the PHP Forum
- Previous Thread: Beginner value transfer across pages
- Next Thread: PHP5 - MySQL Parse error:


Linear Mode