Re: Need a hint on how to display mysql field as a link to a query

Hello,

I need a bit more help.

What you showed me works great. My issue now is I cant display both the firstname and lastname of the golfer.

I would like to show both first and last as one link to another page.

My code:

$firstname = $row[0];
$lastname = $row[1];

echo '<a href="member.php?lastname='.$lastname.'">'.$lastname.'</a>' ;


Thanks

Larry C


"Larry C" <lccronin@xxxxxxxxxxx> wrote in message news:jdtLj.10586$qB1.7181@xxxxxxxxxxx
"Embedded Link" was the term I should have been searching for

Thanks Again

Larry C


"Larry C" <lccronin@xxxxxxxxxxx> wrote in message news:2S9Lj.4231$3w2.1051@xxxxxxxxxxx
Thank you very much

I can work with that and figure it all out.

Larry C



"Floortje" <none@xxxxxxxxx> wrote in message news:47fd2861$0$53214$dbd4b001@xxxxxxxxxxxxxxxxxx
Larry C schreef:
Hello,

Hoping someone can point me in the correct direction. My Google searches are just getting me to many hits.

I have a database for a golf league. I want to display the names of the members but have the name be a link to there own page. I could "hard code" the page but I wanted to have the same option under the page for standings which will vary week to week.

index.php
$sql = "SELECT * FROM MEMBERS";

foreach($db->q($sql) as $member){
echo '<a href="members.php?memberId='.$members['memberId'].'">'.$member['name'].'</a>'
}


members.php
$sql = "SELECT * FROM members WHERE memberId = '.intval($_GET['memberId']).'";

if($db->q($sql)){
// display contents
}


note: change the $db->q() stuff to whatever you would like to use for conecting to the database.


Could someone just point me to a site that could explain it a bit. I need to learn how to do it because I think I want to do something similar with our schedule page.

Thanks

Larry C



.

Relevant Pages