Select record by ID
| From: | nitrox . | 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