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


"Larry C" <lccronin@xxxxxxxxxxx> wrote in message news:ZspMj.7202$Q53.4102@xxxxxxxxxxx

"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

I figured it out. I had the wrong combination of double quotes, quotes, periods, etc. I started the statement from scratch and got it to work.

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

Thanks

Larry C

BTW

Jerry said:
"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."

Jerry you are the one who needs to study *very basic* html. My questioned contained variables. I am not a self proclaimed expert like you but *very basic* html has no variables. It was absolutely a PHP based question.

When someone posts a question you have no idea who they are, what their background is, how long they have looked at the screen and searched for an answer only to get even more confused when a search returns about 10 million hits. If you know the answer or can offer some direction, please do that. The individual posting would appreciate it. If you think the person asking is just looking for an easy way out, don't answer.

Don't be a dill weed and give a little remark like the person asking should know the answer. It lessens the learning process for all and it makes you look a fool.



.

Relevant Pages

  • Re: Redirecting between PHP Pages
    ... but at the very least in a php script. ... > on the outcome of the validation, you want to do one of two things: ... with the various bits of HTML being ... Display login form ...
    (comp.lang.php)
  • Re: Redirecting between PHP Pages
    ... Display login form ... >>other php files, you should never need a redirect your page except to ... pass it on to smarty which then displays it as html for me. ...
    (comp.lang.php)
  • Re: [PHP] Question on sending PhP variable results to an HTML page to be displayed.
    ... > This will not work because the page in question ends in .HTML but I did ... > in .php with the code there. ... > an HTML page and give it lets say to JavaScript to display. ...
    (php.general)
  • Re: does php file size matter?
    ... This file does not display any html, ... >assumption that the only thing that gets transferred to the client is ... >the php file after it has been parsed for all html formatting, ...
    (comp.lang.php)
  • Re: Need Help Building - Dynamic php content using mySQL
    ... > i believe that u have some data stored in mySQL and want to use PHP to ... >> basically I've designed a html page as I would like the output to look. ... >> wherever I've wanted to display dynamic content pulled from mySQL, ...
    (alt.php)