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
>
signature.asc
Description: This is a digitally signed message part
