Select column's default value in MySQL

[Anon]

I want to use PHP to fetch the default value of a certain column in a certain (MySQL) table. Can anyone help?

[Anon]

I think You can send query
$query = "describe $tablename";

and then fetch your row and field.

That's my idea, but i have to check it 🙂

Hamster.

[Anon]

You're right, I just thought of the same thing right after I posted the question. Here's the solution, if anyone should have a similar problem:

$sql = "DESCRIBE $my_table";
$result = mysql_query($sql,$db);
while ($myrow = mysql_fetch_array($result))
if ($myrow['Field'] == $my_column)
{
echo $myrow['Default']; // Yippie!
}
}