Variable for each result in WHILE loop SELECT query

Question

I have a question about PHP WHILE loops. I know that you can perform the action mysql_num_rows to get the number of results from a SELECT query.

But say I have 3 results come through the select query and i put them through a while loop, how do I assign a variable to the number each result is in the mysql_num_row.

Such as
1 for result 1
2 for result 2
3 for result 3.
Sorry if this is a bit confusing, but i can't seem to find an easy way to explain it.

Thanks

Liam Bailey · Accepted Answer · 2012-08-25 12:50:46Z

2

You do it like this:

$results = array();
While ($row = mysql_fetch_assoc($result))
{
$results[] = $row;
}

answered Aug 25, 2012 at 12:50

Liam Bailey

5,9053 gold badges37 silver badges46 bronze badges

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

Comments

Chris · Accepted Answer · 2012-08-25 12:49:42Z

0

$myArray = array();
while($row = mysql_fetch_assoc($result)) {
    $myArray[] = $row
}

answered Aug 25, 2012 at 12:49

Chris

4,38410 gold badges47 silver badges87 bronze badges

Comments

seeker · Accepted Answer · 2012-08-25 12:50:14Z

0

$res=array();
$i=0;
While(mysql_fetch_array(...)){
$i++;
$res[$i]=value
//do logic
}

answered Aug 25, 2012 at 12:50

seeker

3,3637 gold badges42 silver badges72 bronze badges

1 Comment

seeker Over a year ago

@nkr thought that obvious. Edited.

Tieran · Accepted Answer · 2012-08-25 12:54:41Z

0

There are a few 'new' methods for pulling back data from MySQL now, if you're just starting out this might be the ideal time to have a look at them. This looks like a good place to start: http://www.php.net/manual/en/mysqlinfo.api.choosing.php.

answered Aug 25, 2012 at 12:54

Tieran

1,0767 silver badges9 bronze badges

Collectives™ on Stack Overflow

Variable for each result in WHILE loop SELECT query

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related