hello friends
i want to view the field discription of mysql table in my php form ,how can i do this,is there any function to do this
lokking for your suggestion
can i view the field definition of sql table by php code
Moderator: General Moderators
- softsolvers
- Forum Commoner
- Posts: 75
- Joined: Fri Feb 13, 2004 4:26 am
- Location: India
-
tylerdurden
- Forum Commoner
- Posts: 66
- Joined: Mon Jul 28, 2003 11:52 am
- Location: Austria
You can use this:
And continue from there.
Code: Select all
$result = mysql_query("DESCRIBE tablename");
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo "<pre>";
print_r($row);
echo "</pre><br>";
}