How to store one or more column with mysql data in an array

Question

The output I get

Name    Age
ABC     12
PQR     40
XYZ     10

code for retrieving data from MySql database using PHP.

  //Get records from database
  $result = mysql_query("SELECT * FROM people;");

    //Add all records to an array
    $rows = array();
    $count = 0;
    while($row = mysql_fetch_array($result))
    {
     // Here i want to bind one more colomn for count as Row number to array
        count = count + 1;
        $rows[] = $row;
    }

desired output..

RowNo    Name    Age
 1       ABC     12
 2       PQR     40
 3       XYZ     10

I want to send count number with mysql data as one colomn. Can anybody guide me to on that?

Then suggest an alternative instead of saying what not to use. — Raceimaztion
– Raceimaztion, Commented Sep 9, 2013 at 9:03
Similar question here: stackoverflow.com/questions/3126972/mysql-row-number (you don't have to iterate through anything in PHP, you can get it from mysql) — user2409138
– user2409138, Commented Sep 9, 2013 at 9:16

Bere · Accepted Answer · 2013-09-09 09:01:01Z

2

while($row = mysql_fetch_array($result))
{
    $count = $count + 1;
    $row['RowNo']= $count; //Just add this
    $rows[] = $row;
}

answered Sep 9, 2013 at 9:01

Bere

1,7472 gold badges17 silver badges23 bronze badges

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

Comments

Essam Elmasry · Accepted Answer · 2013-09-09 09:05:15Z

0

try this

$counter = 0;
for($i = 0; $i < count($result); $i++)
{
   $counter++;
   $result[$i]['rowcount'] = $counter;
}

answered Sep 9, 2013 at 9:05

Essam Elmasry

1,25211 silver badges11 bronze badges

Collectives™ on Stack Overflow

How to store one or more column with mysql data in an array

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related