The first thing that I probably do is to check for possible errors from DB: $result = mysql_query("SELECT * FROM inf_member WHERE user_id='$user_id' "); if ( ! $result ) { die ("Could not perform query $query: ".mysql_error()."\n"); } Regards, On dom, 2007-01-28 at 18:21 -0500, nitrox . wrote: > 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 >
Attachment:
signature.asc
Description: This is a digitally signed message part