"; echo " Id Mycotoxin species Product Geographic location Method analysis Source of the data Years Edit Delete "; while($row = mysql_fetch_array( $result )) { echo ""; echo '' . $row['id'] . ''; echo '' . $row['mycotoxin_species'] . ''; echo '' . $row['product'] . ''; echo '' . $row['location'] . ''; echo '' . $row['method_analysis'] . ''; echo '' . $row['source_of_the_data'] . ''; echo '' . $row['years'] . ''; echo 'Edit'; echo 'Delete'; echo ""; } echo ""; ?>

Insert new record

----------------------------------------------------------------------------------------------------- Insert Records '.$error.''; } ?>
Insert Records
Mycotoxin species*
Product*
Location*
------------------------------------------------------------------------------------------- Edit Records '.$error.''; } ?>
Edit Records
Mycotoxin species*
Product*
Location*
0) { $id = $_GET['id']; $result = mysql_query("SELECT * FROM record WHERE id=$id") or die(mysql_error()); $row = mysql_fetch_array($result); if($row) { $mycotoxin_species = $row['mycotoxin_species']; $product = $row['product']; $location = $row['location']; valid($id, $mycotoxin_species, $product, $location,''); } else { echo "No results!"; } } else { echo 'Error!'; } } ?> ------------------------------------------------------------ ---------------------------------------------------------