October 28, 2006 on 4:30 am | In php |
$output = ?; $query = SELECT * FROM $tableName ?; $result = mysql_query($query, $dbConn); $output .=
\n ?; //get column headings//get field names$output .=
\n ?; while ($field = mysql_fetch_field($result)){ $output .=
| $field->name |
\n ?; } // end while//get name of index field (presuming it s first field) $keyField = mysql_fetch_field($result, 0); $keyName = $keyField->name; //add empty columns for add, edit, and delete$output .=
|
|
\n ?; $output .=
\n\n ?; //get row data as an associative arraywhile ($row = mysql_fetch_assoc($result)){ $output .=
\n ?; //look at each fieldforeach ($row as $col=>$val){ $output .=
| $val |
\n ?; } // end foreach//build little forms for add, delete and edit//delete = DELETE FROM
WHERE = $keyVal = $row[ $keyName ?]; $output .= <<< HERE
|
|