Retrieving default value of mysql fields

Anon

I've browsed through the manual and the forums for an hour and a half and can't find an answer to this anywhere.

How do I retrieve the default values of mysql fields in PHP4??

I'm sure this must be one of those "damn I'm stupid" questions, but please be generous and help me out!

Thanks,
Scott

Anon

Try this:

$Conn = mysql_connect("blabla","blablabla","blablablabla");

$Query = mysql_query("SELECT * FROM table",$Conn);
$rows = mysql_num_fields($Query);

for($i=0;$i<$rows;$i++){

echo "Field name: ".mysql_field_name($Query,$i)." ";
echo "Field type :".mysql_field_type($Query,$i)." ";
echo "Field lenght :".mysql_field_len($Query,$i)." ";

}

You can also use a query like this:

SHOW FIELDS FROM tablename

I leave up to you getting to know what that query does.

Cheers

fLIPIS

Anon

Thanks, but that is not quite what I needed. I did find a good way to do it.

For anyone reading this and is interested in how I do it:

$sql="DESCRIBE database.table";
$result=@($sql);

while($myrow=@mysql_fetch_array($result))
{
echo "myrow_Field=".$myrow["Field"]." ";
echo "myrow_Type=".$myrow["Type"]." ";
echo "myrow_Null=".$myrow["Null"]." ";
echo "myrow_Key=".$myrow["Key"]." ";
echo "myrow_Default=".$myrow["Default"]." ";
echo "myrow_Extra=".$myrow["Extra"]." ";
}

All these fields are returned by the DESCRIBE keyword in sql.
Scott

Anon

SHOW FIELDS FROM table returns the same, at least in MySQL. Anyway, i didn't know this way to do it.

fLIPIS