"; $field_count = mysql_num_fields ($result); for ($i =0;$i < $field_count;$i++) { $field_name = mysql_field_name ($result, $i); //capture field name $field_type = mysql_field_type ($result, $i); //capture field data type $field_type = strtoupper ($field_type); $field_flags = mysql_field_flags($result, $i); //capture other field info $field_flags = strtoupper ($field_flags); $field_len = mysql_field_len ($result, $i); if (strstr($field_flags, "AUTO_INCREMENT")) $format = "Auto Incr. Field"; elseif (strstr($field_type, "DATE")) $format = "yyyy-mm-dd"; else $format = ""; if (strstr($field_flags, "PRIMARY_KEY")) $field_flags = "PRIMARY KEY"; //add to the form,one row for each field $form_block .=" "; } //finish up the form $form_block .="
Field Name Data Type Length Field Flag Format Enter Value
After inserting this record, do you want to insert another record? YES NO
Add Records: step 2

Step 2: Add Records

Table Name:
Database Name: