PHP MYSQL mysql_fetch_array, loop. right way to go?

Question

I have a query that returns a few rows, and I have the following lines of code to retrieve them:

$result_set = mysql_query($query);

while($net_biz_sub_data[]=
 mysql_fetch_array($result_set,MYSQL_ASSOC));

My question is what is the right way to retrieve that db query data without getting the last array empty ? When I count() it is always num of rows + 1, and I would like to correct that.

The return value of count() is accurate. Arrays are zero indexed. Use < count() instead of <= count(). — jasonbar
– jasonbar, Commented Oct 3, 2011 at 18:13
-0.25 for still using mysql_query. What half-assed site/book/whatever is presenting that as an example of modern best practices? — cHao
– cHao, Commented Oct 3, 2011 at 18:14

cHao · Accepted Answer · 2011-10-03 18:16:22Z

7

Because of the way the while loop works, you should do

while($dataz = mysql_fetch_assoc($result_set))
{
    $net_biz_sub_data[] = $dataz;
}

edited Oct 3, 2011 at 18:16

cHao

87k21 gold badges147 silver badges178 bronze badges

answered Oct 3, 2011 at 18:12

Jan Dragsbaek

8,1212 gold badges28 silver badges46 bronze badges

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

Comments

genesis · Accepted Answer · 2011-10-03 18:12:39Z

1

Use

$result_set = mysql_query($query);

while($net_biz_sub_data = mysql_fetch_assoc($result_set)){
    //use $net_biz_sub_data here
}

answered Oct 3, 2011 at 18:12

genesis

51.1k20 gold badges99 silver badges127 bronze badges

Collectives™ on Stack Overflow

PHP MYSQL mysql_fetch_array, loop. right way to go?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related