retrive field names
Moderator: General Moderators
retrive field names
How to retrive all field names from db
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
Burrito was right. "describe tablename" or "show columns in tablename" both work ...
Code: Select all
$conn = mysql_connect();
mysql_select_db();
$query = "show columns in tablename";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result))
{
echo "$row[0]<br />\n";
}
mysql_close();