User Name Password Register
DaniWeb IT Discussion Community
All
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,924 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,364 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: 897 | Replies: 1
Reply
Join Date: Jan 2006
Posts: 29
Reputation: rcasinillo_s is an unknown quantity at this point 
Rep Power: 3
Solved Threads: 0
rcasinillo_s rcasinillo_s is offline Offline
Light Poster

Please help me!!!

  #1  
Jan 16th, 2006
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
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Oct 2005
Posts: 25
Reputation: calcop is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 0
calcop calcop is offline Offline
Light Poster

Re: Please help me!!!

  #2  
Jan 22nd, 2006
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?
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb PHP Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Other Threads in the PHP Forum

All times are GMT -4. The time now is 11:52 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC