[SOLVED] Row number in mysql

[Panjabel]

it is posible to get the result row number in php from mysql ?

thanks

[Panjabel]

up

[keeB]

Sure...

 

Say, for example, your query engine looks something like this:

 

<?php
$new = array();
while ($row = mysql_fetch_array($result)) {
    array_push($row, $new);
}

for($i=0, $i<count($new); $i++) {
   print "iterating through result: " . $i . "<br> contains  " . $new[$i] . "<br>";
}

 

 

?>

 

 

 

 

[wildteen88]

If the table you are querying contains an id column. include the id column in your query, eg:

 

<?php
$sql = "SELECT id, another_column, col_x FROM tbl_name_here";
$result = mysql_query($sql);

while($row = mysql_fetch_assoc($result))
{
    echo $row['id'] . ' - ' . $row['another_column'] . ' - ' . $row['col_x'] . '<br>';
}
?>