Re: MySQL....

Article View: dk.edb.database

Article #15057

#15057

From: Henrik Hansen
Date: Wed, 25 Jul 2001 07:58

24 lines
1569 bytes

"MiG" <clark@cool.dk> wrote:

 > Hvis man kun vil hente fra en r�kke, hvad g�r man s�?? Er det her rigtigt??
 > 
 >   $result = mysql_query("select * from users where user = $user");
 >   while ($row = mysql_fetch_array($result))
 >     {
 >       echo "User: ".$row['user']."<br>
 >         Pass: ".$row['pass']."";
>    }

Hvis du kun vil hente en r�kke er der ingen grund til at bruge en
while p� fetch_array da der jo kun er en r�kke og derfor intet at l�be
igennem.

derfor:
$result = mysql_query("select * from users where user = $user");
$row = mysql_fetch_array($result);

echo "User: ".$row['user']."<br>";
Pass: ".$row['pass']."";

-- 
Henrik Hansen

Technical Details

Message-ID: <uofq9jv8p.fsf@mailserver.dk>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!skynet.be!news.tele.dk!212.97.206.81!kinglear.mobilixnet.dk!news.tele.dk!not-for-mail

References: <9jlq49$19ps$1@news.cybercity.dk>

Show Full Headers

Complete Article Headers

X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,c544d0c394a1d08d
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-07-25 00:56:39 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!skynet.be!news.tele.dk!212.97.206.81!kinglear.mobilixnet.dk!news.tele.dk!not-for-mail
Newsgroups: dk.edb.database
Subject: Re: MySQL....
References: <9jlq49$19ps$1@news.cybercity.dk>
From: Henrik Hansen <hh@mailserver.dk>
Date: Wed, 25 Jul 2001 09:58:14 +0200
Message-ID: <uofq9jv8p.fsf@mailserver.dk>
User-Agent: Gnus/5.090004 (Oort Gnus v0.04) Emacs/20.7
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Lines: 24
Organization: TDC Internet
NNTP-Posting-Host: 193.88.249.39
X-Trace: 996047798 dread01.news.tele.dk 352 193.88.249.39
X-Complaints-To: abuse@post.tele.dk

Reply to Parent Message