A way to get the field lengh into PHP?

[jplush76]

I need to write a script that pads the fields I selected.

Instead of having to hard code each field individually.. is there a way to set up a loop that compares the value of the data to the length of the whole field like....

First_Name has is a 32 Character field

the data in the first row holds "John"

well I need the rest of those characters to be blank spaces.

Any thoughts?

thanks a million! 🙂

[jplush76]

here is the code I've been messing with:

$result = query_db("select user_first, user_email from user;");

$num_rows = mysql_numrows($result);

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

$rows = mysql_fetch_array($result);
$name = ($rows["user_first"]);

$flen = mysql_field_len($result, $name);

$slen = strlen($name);

if($slen < $flen){

$sfield = $name.str_repeat("&nbsp;", $flen - $slen);

echo $sfield;

}

}

now that just gives me what I need for one field, how do I loop that for the 30 fields I'll need for my real query?

would mysql_fetch_lengths be a better tool for this?

[brandonschnell]

str_pad($name, 32)

http://www.php.net/manual/en/function.str-pad.php

check the params, i haven't used that function in a long time.