PHP Get row 'id' from MySQL query results

Question

I read somewhere (sorry I forgot where), that there is a way to associate an index number to rows fetched from an MySQL query result using a native PHP function (the person was not sure about the syntax so he didn't wrote it). For example:

The usual way:

$count = 1;
while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
    echo "<li> ". $count ."id: " . $row['id'] . " lon: " . $row['lon']. ", lat: ". $row['lat'].", ". $row['road']. " </li>";
    $count++;
}

I know that thinking of this other way is not that important, but I'm just curious if there really is a function for that purpose.

$row['id'], it's right there...Or do you just want to retrieve the id and not the rest? Or? Row count? row number? not clear to me, sorry.. — Damien Pirsy
– Damien Pirsy, Commented Feb 21, 2011 at 12:27
Doesn't the table you're fetching from has it's own primary key? — HyderA
– HyderA, Commented Feb 21, 2011 at 12:32
Were you thinking of mysql_num_rows (deprecated) to retrieve the count? Then loop over result using that? (not recommended) — Greg K
– Greg K, Commented May 7, 2019 at 11:07

Haim Evgi · Accepted Answer · 2011-02-21 12:31:37Z

3

you can add rownum to your results array, if you edit your sql like

SELECT @rownum:=@rownum+1 as rownum, p.* FROM MYTABLE p , (SELECT @rownum:=0) r

so the loop like

    while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
        echo "<li> ". $row['rownum'] ."id: " . $row['id'] . " lon: " . $row['lon']. ", 
        lat: ". $row['lat'].", ". $row['road']. " </li>";

    }

answered Feb 21, 2011 at 12:31

Haim Evgi

126k46 gold badges222 silver badges226 bronze badges

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

1 Comment

John Bautista Over a year ago

So there is no native PHP-MySQL function for that. Thanks for the @rownum. I didn't know that.

Collectives™ on Stack Overflow

PHP Get row 'id' from MySQL query results

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related