Beiträge von bluebird

    [php:1:cb42dbd04e]



    <?php



    $sql= "SELECT * FROM users ORDER BY `userid` = '$id'";


    $result = mysql_query($sql);

    $row = mysql_fetch_assoc($result);


    $id = $row['UserID'];
    $name = $row['UserName'];
    $email = $row['UserMail'];
    $hp = $row['UserHp'];
    $icq = $row['UserIcq'];
    $msn = $row['UserMsn'];

    echo"


    <form action='profiles?id=$id' method='post'>


    <table width='154' border='0' align='center' cellpadding='0' cellspacing='0'>
    <tr>
    <td width='42'>id:</td>
    <td width='120'>$id</td>
    </tr>
    <tr>
    <td>name:</td>
    <td>$name</td>
    </tr>
    <tr>
    <td>Mail:</td>
    <td>$email</td>
    </tr>
    <tr>
    <td>Homepage:</td>
    <td>$hp</td>
    </tr>
    <tr>
    <td>ICQ:</td>
    <td>$icq</td>
    </tr>
    <tr>
    <td>MSN:</td>
    <td>$msn</td>
    </tr>
    </table>


    </form>
    ";
    ?>



    [/php:1:cb42dbd04e]



    jetzt müsste es klar werden ...

    Guten Morgen zusammen,
    es geht um folgende codezeile:


    Code
    1. $sql= "SELECT * FROM users ORDER BY UserID = '$id' ";


    daraufhin bekomme ich folgende fehlermeldung:


    Notice: Undefined variable: id in [...]