DB Query Returns

[eluser]ELRafael[/eluser]
ah! now i got it :cheese:

Are you using MySQL???

if yes, you can use a desc statement

Let'me see.

My table

TB_NAMES
+---------+-------------+
| Field | Type |
+---------+-------------+
| id | int(4) |
| name | varchar(20) |
| surname | varchar(30) |
+---------+-------------+

So, i can use a DESC

Code:

$sql = "DESC TB_NAMES";
$query = $this->db->query($sql);

//Blah blah blah

Sorry, but here i'm using MS SQL, so if i need something, i can get in the sys_ tables. But this should work.


Maybe i'll be late to answer again!!! Lunch time here now (13:00pm) and i wanna see a sport show in tv (about brazil x equador). But i'll be back!