[eluser]Unknown[/eluser]
Hello Please help me
I Want to retrive data following way from table
------------------------------------
Sr. No To Matter
------------------------------------
1 XYZ dsfsd
2 PQR sdsdfsdf
3 zxc sasfas
.
.
------------------------------------
so query is
$q = $this->db->query('set @c:=0;
Select (@c:=@c+1)as sr ,a.id,a.to,a.matter,date(a.timestamp) as dt, time(a.timestamp) as tm, b.firstname from notice a, userinfo b where a.userid=b.userid');
it gives error plz help me.
thanks in advance
