Select record by ID

From: Date: Sun, 28 Jan 2007 23:21:29 +0000
Subject: Select record by ID
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-247917@lists.php.net to get a copy of this message
Before I ask my next question I just wanted to thank you all for being in this mailing community and sharing your knowledge. Its communitys like this that make life easier for all of us. Ok enough with the mushy stuff Im trying to display one record at a time by ID. Well im getting a blank page. Ive looked over my code and tried 20 different ways to get it to work to no avail. So any pointers on what Im doing wrong would be great. here is the code im working with so far. <?php include("db.php");
       $result = mysql_query("SELECT * FROM inf_member WHERE user_id='$user_id' ");
       while($myrow = mysql_fetch_assoc($result))
             {
                    echo "<b>";
                    echo $myrow['user_name'];
                    echo "</b>";
                    echo $myrow['rank'];
echo "</b>";
                    echo $myrow['country'];
echo "</b>";
                    echo $myrow['email'];
                    echo "</b>";
                    echo $myrow['quote'];
                    echo "</b>";
                    echo $myrow['config'];
echo "</b>"; echo $myrow['map'];
                    echo "</b>";
                    echo $myrow['gun'];
                    echo "</b>";
                    echo $myrow['brand'];
echo "</b>"; echo $myrow['cpu']; echo "</b>";
                    echo $myrow['ram'];
                    echo "</b>";
                    echo $myrow['video'];
                    echo "</b>";
                    echo $myrow['sound'];
echo "</b>"; echo $myrow['monitor'];
                    echo "</b>";
                    echo $myrow['mouse'];
                    echo "</b>";
                    echo $myrow['brand'];
echo "</b>";
            }
?> _________________________________________________________________ FREE online classifieds from Windows Live Expo – buy and sell with people you know http://clk.atdmt.com/MSN/go/msnnkwex0010000001msn/direct/01/?href=http://expo.live.com?s_cid=Hotmail_tagline_12/06

« previous php.general (#247917) next »