Is there a way i can give a row in its order from a query (with ORDER BY and LIMIT in)
Such as the second returned will be 2.
But also to take into account the limit?
Might be easier to assign the number in php while reading the results.
Indeed, the simplest method is to count in PHP.
Looks like i will have to... was hoping to make the code as least messy as possible
Where's the mess in:
<? $iCounter=0; while ($row=mysql_fetch....) { echo $iCounter++; };