Help this is crucial

  • 18 years ago

    <?
    mysqlpconnect("localhost","root","");
    mysql
    selectdb("psn");
    $result = mysql
    query("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","");
    mysql
    selectdb("psn");
    $result = mysql
    query("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

  • 18 years ago

    its ok no help needed

Post a reply

Enter your message below

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“If Java had true garbage collection, most programs would delete themselves upon execution.” - Robert Sewell