Re: Select record by ID

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux