Re: Number of bytes in a field?
| From: | Cam Dunstan | Date: | Wed, 02 Oct 2002 23:16:06 +0000 |
| Subject: | Re: Number of bytes in a field? | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-16136@lists.php.net to get a copy of this message | ||
kieran, try this ...
$fieldresult = mysql_list_fields($some_database, $some_table);
$fieldcount = mysql_num_fields($fieldresult);
for ($my_counter = 0; $my_counter < $fieldcount; $my_counter++} {
$fieldsize = mysql_field_len($fieldresult, $my_counter);
echo "fieldsize = ".$fieldsize;
echo "<br>";
}
other useful field informatiomn functions are ...
$fieldname = mysql_field_name($fieldresult, $my_counter);
$fieldtype = mysql_field_type($fieldresult, $my_counter);
----- Original Message -----
From: "Kieran Hall" <kieran_hall@blueyonder.co.uk>
To: <php-windows@lists.php.net>
Sent: Thursday, October 03, 2002 7:26 AM
Subject: [PHP-WIN] Number of bytes in a field?
> Does anyone know of a way to get the number of bytes from a mysql field?
>
>
> *********************************************************************
> Kieran Hall
> *********************************************************************
>
>