Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Location
    Varrok
    Posts
    863
    Tokens
    0

    Default Php.. can someone help

    Im trying to do it so it only shows rows with the id 1.. thanks
    PHP Code:
    <?
    ob_start
    ();
    include(
    "config.php");
    {
    $getquest mysql_query("SELECT * from questinfo ORDER BY `id` DESC LIMIT 0 , 1");
    while (
    $quest mysql_fetch_array($getquest))

    ?>
    <img src="images/book_open.png"> Quest's - <? echo ("$quest[Quest_Name] "?></div>
    <p>
    <b>Quest Name: </b><? echo ("$quest[Quest_Name] "?></a></font></td>
    <br><b>Quest Difficulty: </b><? echo ("$quest[Quest_Difficulty] "?><b><br>
    Quest Length: </b><? echo ("$quest[Quest_Length] "?> <b><br>
    Quest Points Reward: </b><? echo ("$quest[Quest_Points] "?><br>
    <hr color="#e5e5e5" noshade="noshade" size="1"></p><p></b><b>Requirement's: </b><? echo ("$quest[Quest_Requirements] "?><br>
    <b>Item's Needed: </b><? echo ("$quest[Quest_Itemsneeded] "?><bR>
    <b>Reward: </b><? echo ("$quest[Quest_Reward] "?>
    <br><b>Start Point:</b> <? echo ("$quest[Quest_Startpoint] "?><br>
    <b>To Start:</b> <? echo ("$quest[Quest_Tostart] "?></p>
    <hr color="#e5e5e5" noshade="noshade" size="1"><p>
    <u><b>Quest Guide</b></u><br>
    <? echo ("$quest[Quest_Guide] "?>


    </p>
    <hr color="#e5e5e5" noshade="noshade" size="1">
    <?
    }
    }
    ?>

  2. #2
    Join Date
    Apr 2006
    Location
    England
    Posts
    1,159
    Tokens
    0

    Latest Awards:

    Default

    $getquest = mysql_query("SELECT * from questinfo WHERE id = '1' ORDER BY `id` DESC LIMIT 0 , 1");

    perhaps?
    REMOVED

    Edited by jesus (Forum Super Moderator): Please do not have text in your signature which is over size 4.

  3. #3
    Join Date
    May 2006
    Location
    Varrok
    Posts
    863
    Tokens
    0

    Default

    thanks =]] + rep

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •