obtaining mysql data without while loop to reduce speed?

Question

If I only have one row that I'm getting through

$sql = mysql_query("SELECT id,user,comments FROM user WHERE id='15' AND user = '15'");

is there a way to just get the comments from that one row without going through a while loop :

while($row = mysql_fetch_array($sql)){
$comments = $row['comments'];
}

Is there something similar besides using a while loop? If my data has thousands to millions of data, a while loop will take a long time? Is this a more logical way to locate a certain row and reduce its speed?

Thanks for your help!

Ignacio Vazquez-Abrams · Accepted Answer · 2011-10-25 05:27:10Z

4

If you're only returning one row then only fetch once.

if ($row = mysql_fetch_array($result))
{
  $comments = $row['comments'];
}

answered Oct 25, 2011 at 5:27

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

designosis · Accepted Answer · 2011-10-25 05:30:34Z

1

$sql = mysql_query("
SELECT id,user,comments 
FROM user 
WHERE id='15' 
AND user = '15' 
LIMIT 1");

The LIMIT 1 will stop the query after the first result

answered Oct 25, 2011 at 5:30

designosis

5,2631 gold badge42 silver badges58 bronze badges

3 Comments

Ignacio Vazquez-Abrams Over a year ago

And what about fetching the results?

designosis Over a year ago

you can still use while, or if as Ignacio suggested, either will test for a result first. if you're not going to use an } else { condition (to handle what happens when no records are returned), you could just use $row = mysql_fetch_array($result); on it's own.

designosis Over a year ago

but the performance issue was handled via LIMIT 1, and it doesn't really matter how you access the data.

Rukmi Patel · Accepted Answer · 2011-10-25 05:32:01Z

0

when you have more than one rows in resultset, then and then only you need to do it in loop else to fetch single row you are not required to put result set in loop.

you can do it like this..

if(mysql_num_rows($result) == 1){
   if($row = mysql_fetch_array($result)){
       $comments = $row['comments']; 
   }
}

answered Oct 25, 2011 at 5:32

Rukmi Patel

2,5619 gold badges29 silver badges42 bronze badges

Collectives™ on Stack Overflow

obtaining mysql data without while loop to reduce speed?

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related