note 16794 added to function.mysql-field-type
| From: | blue-lake at prodigy dot net | Date: | Wed, 14 Nov 2001 02:09:01 +0000 |
| Subject: | note 16794 added to function.mysql-field-type | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-20810@lists.php.net to get a copy of this message | ||
Well just to add appon getting mySQL types. The way i do it is...
$mytable = "whatever";
$mydatabase = "whatever";
$type = mysql_db_query($mydatabase, "SHOW FIELDS FROM $mytable") or mysql_die();
while($row = mysql_fetch_array($type))
{
echo "Field<br>".$row[Field];
echo "Type<br>".$row[Type];
}
--
http://www.php.net/manual/en/function.mysql-field-type.php
http://master.php.net/manage/user-notes.php?action=edit+16794
http://master.php.net/manage/user-notes.php?action=delete+16794
http://master.php.net/manage/user-notes.php?action=reject+16794