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

Larry C wrote:

"Jerry Stuckle" <jstucklex@xxxxxxxxxxxxx> wrote in message news:oaqdnSK80Ov0_5zVnZ2dnUVZ_hisnZ2d@xxxxxxxxxxxxxx
Larry C wrote:
"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



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
>
>

First of all, how do you identify the golfer? That's what needs to go into the link.

You can display both first name and last name with no problem. The link to page isn't necessarily the same as what is displayed.

For instance - you could have:

<a href="http://www.example.com/score.php?golfer=3";>Tiger Woods</a><br>
<a href="http://www.example.com/score.php?golfer=15";>Ernie Els</a>

The fist link will display "Tiger Woods" but will link to www.example.com/score.php and pass the parameter "golfer=3". The second one will display "Ernie Els" but link to the same page with golfer=15.

You really need to study up on basic HTML. These aren't really PHP questions (although the links are generated by PHP) but *very basic* html.

P.S. Please don't top post. Thanks.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@xxxxxxxxxxxxx
==================


Jerry,

I am identifying the golfer by their lastname. I also want to display the golfers firstname and lastname on the page. I am getting the names of the golfers from a database.

I am not sure how your answer helps me.

Larry C



First of all, you probably shouldn't be identifying the golfer by his last name - what happens if you have a John Smith and a Joe Smith? Or even worse, two John Smith's? Rather, you should have a unique id in the database for each golfer.

But my point above still stands. The parameter you're passing in the link is what will be used to access the data. But what the user sees can be different. Think if the number of times you've seen a "click here" or similar link, which doesn't have anything related to the link itself being displayed.

So in the text itself, you put both the first and last names of the golfer. But in the link you put just the last name, similar to what I showed you above.

The code I showed you before displays "Tiger Woods", but the link will be to "www.example.com/score.php?golfer=3". All you need to do is replace the "3" with "Woods" and you'll pass the last name onto the new page.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@xxxxxxxxxxxxx
==================

.

Relevant Pages