By Apfel007 on
Hi,
I like to make a query witch stores the row number of each query result. The query should run every day one time and I like to store the number of the last row, cause of setting "limit" for the day. Could someone help my to fix this sql..
mytable
myfield
-------
name1
name2
name3 / day1
...
name100 / day2
...
name500 / day3
as a result I like to have something like that
name[table_row_0] = name1
name[table_row 1] = name2
......
This is working..
...
$sid = 'mytable';
$sql = "select @rownum:=@rownum+1 ‘rank’, p.* from {$sid} p, (SELECT @rownum:=0)";
