+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: Database Problem (/showthread.php?tid=51506)
Database Problem - El Forum - 05-07-2012
[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