Help this is crucial

• • Reply

  18 years ago

  by psn

  psn

  , United States

  Joined 18 years ago

  <?
  mysqlpconnect("localhost","root","");
  mysqlselectdb("psn");
  $result = mysqlquery("SELECT * FROM clubs WHERE league='nsl' ORDER by name ASC");
  while($r=mysqlfetcharray($result))
  {
  $clubname=$r["name"];
  $emblem=$r["emblem"];
  $id=$r["id"];
  echo "<tr><td><div class=''><img src='images/$emblem'width='30'height='15'><a href='club.php?id=$id'class='body'>$clubname</a></div></td>";}?>
  

  
  This code is where there are clubs.
  

  
  The next script is clubs profile
  ?
  mysqlpconnect("localhost","root","");
  mysqlselectdb("psn");
  $result = mysqlquery("SELECT * FROM clubs WHERE id='$id'");
  while($r=mysqlfetcharray($result))
  {
  $id=$r["id"];
  $name=$r["name"];
  $manager=$r["manager"];
  $wmessage=$r["wmessage"];
  $history=$r["history"];
  $honors=$r["honors"];
  $stadiumaddress=$r["stadiumaddress"];
  $picture=$r["picture"];
  $website=$r["website"];
  $emblem=$r["emblem"];
  $league=$r["league"];
  

  
  

  
  echo "<tr><td><img src='images/$emblem'width='120'height='150'></td><tr><td></td>";}?>
  Its not exaclty finished. But I want to be able to click on a link in the first script and have the profile pop up in the second script
  How do I do that?
  The table in both are the same.
  

  
  

  
  In a more explained way.
  1) You goto the leagues page in this case australia.php there are teams which are linked they goto the second script.
  2) Thry have clubs.php?id=$id
  3) Then we goto clubs.php and from there it doesn't work.
  4) I want it to open the profile of the selected link from australia.php from it's id in the link
  

  Report abuse
• • Reply

  18 years ago

  by psn

  psn

  , United States

  Joined 18 years ago

  its ok no help needed

  Report abuse