Ops!, Better this one:
$query = "SELECT inf_member WHERE user_id='$user_id' ";
$result = mysql_query($query);
if ( ! $result ) {
die ("Could not perform query $query: ".mysql_error()."\n");
}
I did copy and paste from my own code and you've not $query defined on
your one. I prefer to store first the query on a string to show it
complete if there's an error late, because it may show also the point.
On lun, 2007-01-29 at 00:39 +0100, Francisco M. Marzoa Alonso wrote:
> The first thing that I probably do is to check for possible errors from
> DB:
>
> $result = mysql_query("SELECT 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
