help me please
Posted: Wed Jul 24, 2002 1:05 am
<?
mysql_pconnect("localhost","root","");
mysql_select_db("psn");
$result = mysql_query("SELECT * FROM clubs WHERE league='nsl' ORDER by name ASC");
while($r=mysql_fetch_array($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
?
mysql_pconnect("localhost","root","");
mysql_select_db("psn");
$result = mysql_query("SELECT * FROM clubs WHERE id='$id'");
while($r=mysql_fetch_array($result))
{
$id=$r["id"];
$name=$r["name"];
$manager=$r["manager"];
$wmessage=$r["wmessage"];
$history=$r["history"];
$honors=$r["honors"];
$stadium_address=$r["stadium_address"];
$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.
mysql_pconnect("localhost","root","");
mysql_select_db("psn");
$result = mysql_query("SELECT * FROM clubs WHERE league='nsl' ORDER by name ASC");
while($r=mysql_fetch_array($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
?
mysql_pconnect("localhost","root","");
mysql_select_db("psn");
$result = mysql_query("SELECT * FROM clubs WHERE id='$id'");
while($r=mysql_fetch_array($result))
{
$id=$r["id"];
$name=$r["name"];
$manager=$r["manager"];
$wmessage=$r["wmessage"];
$history=$r["history"];
$honors=$r["honors"];
$stadium_address=$r["stadium_address"];
$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.