echo the field type

[jeff5656]

$query = "SELECT * FROM `people` WHERE `s_status` = 'a'  order by $srt";
$results = mysql_query ($query) or die (mysql_error());
while ($row = mysql_fetch_assoc ($results)) {
echo $row['f13'] . "this field type is"."?????";

Where the ???? are in the code above, what do I put there to echo the filed type (i.e. "varchar" or "Date", etc?

[litebearer]

this may guide you...

 

http://www.java2s.com/Code/Php/MySQL-Database/Getcolumnnametypeandmaxlength.htm

 

 

[litebearer]

Also...

http://www.w3schools.com/php/func_mysql_field_type.asp

 

[jeff5656]

I apologize I could not undertand how to use the first link:

for($count=0;$count<$fields;$count++) {

      $field = mysql_fetch_field($result,$count);

      echo "<p>$field->name $field->type ($field->max_length)</p>";

 

and apply that to my code.  what is "field ->type"??

 

If I have $row['f13'] how do I see what data type that is? 

 

Yoir send link: mysql_field_type(data,field_offset)

 

What is a field offset?  I do not know what number to start at.