DaniWeb Forum Index > Web Development > PHP

Result without while loop

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Apr 2008

Posts: 496

Reputation: veledrom is an unknown quantity at this point

Solved Threads: 0

veledrom

Offline

Posting Pro in Training

Result without while loop

Feb 27th, 2009

Hi,

Code below always returns only 1 record therefore i don't need while. How can i get result without while loop?

Thanks

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$q="SELECT id FROM login WHERE username='$username'";
$sql=mysql_query($q);
 
if (@mysql_num_rows($sql)==1) {
while ($arr=mysql_fetch_array($sql)) {
$id=$arr["id"];
}
}
$q="SELECT id FROM login WHERE username='$username'";
$sql=mysql_query($q);

if (@mysql_num_rows($sql)==1) {
while ($arr=mysql_fetch_array($sql)) {
$id=$arr["id"];
}
}

•

Join Date: Nov 2007

Posts: 3,760

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: Result without while loop

Feb 27th, 2009

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$q="SELECT id FROM login WHERE username='$username'";
$sql=mysql_query($q);
if (@mysql_num_rows($sql)==1) {
$arr=mysql_fetch_array($sql);
$id=$arr["id"];
}
$q="SELECT id FROM login WHERE username='$username'";
$sql=mysql_query($q);
if (@mysql_num_rows($sql)==1) {
$arr=mysql_fetch_array($sql);
$id=$arr["id"];
}