checking length of query result

[Anon]

If I return a result from a query with mysql_fetch_array and need to check the character length of a specific field, what is the best way?

I have tried mysql_field_len but am getting errors with the code below:

$getInfo = mysql_fetch_array($c1->sqlQuery);
$firstName=$getInfo["first_name"];
$lastName=$getInfo["last_name"];
$firstNameLen=mysql_field_len($firstName, 0);
$lastNameLen=mysql_field_len($lastName, 0);

Any advice is appreciated

[Anon]

well according to zend the mysql_field_len is used in a different manner than the way you are using it.

int mysql_field_len (resource result, int field_offset)

so to use it correctly, i think, you would do it like this:

mysql_field_len($getInfo,$getInfo["first_name"])

i am not sure if the is the right way to do it because the resource result is $getInfo but the offset might be the MYSQL_NUMS value/number reference to the $getInfo array.