the insert is working but everytime you refresh it even if you don't put anything in the fields it puts in cached data. how do i set the script to do nothing?
Thank you for any pointers
<?
if ($_POST['add'])
{
$errorcodes = trim($_POST['errorcodes']);
$errornum = trim($_POST['errornum']);
$description = trim($_POST['description']);
if ($errorcodes == '0') {
$errorcodes = '';
}
if ($errornum == '0') {
$errornum = '';
}
if ($description == '0') {
$description = '';
}
$query = "INSERT INTO tblnick (errorcodes,errornum,description)
VALUES ('$errorcodes','$errornum','$description')";
$result = mysql_query ($query) or die('Error, query failed');
echo "<br><b><img src=/images/green.bmp> The error codes has been successfully added!</b><br><br>";
}
?>
<br><tr><td><b>
<font face="Verdana, Arial" size="3">
Error Codes
</font>
</b><br><hr><br>
<b> These error codes are returned by the Windows® Installer functions MsiExec.exe and InstMsi.exe. Note that any error in Winerror.h (such as ERROR_INVALID_DATA, included here) can be returned as well.</b><br>
<table border=1>
<td bgcolor=#187DAD>Error code</td>
<td bgcolor=#187DAD>Value</td>
<td bgcolor=#187DAD>Description</td>
<?php
$query = "select * from tblnick";
$result = mysql_query ($query);
while($row = mysql_fetch_array($result)){
echo "<tr>";
echo "<td>";
echo $row['errorcodes'];
echo "</td>";
echo "<td>";
echo $row['2'];
echo "</td>";
echo "<td>";
echo $row['3'];
echo "</td>";
echo "</tr>";
}
echo "</table>";
?>
<form method="post" action="http://index.php?page=dev">
<TABLE>
<TR>
<TD>Error Codes</TD>
<TD><INPUT TYPE='TEXT' NAME='errorcodes' VALUE='' width=255></TD>
</TR>
<TR>
<TD>Error num</TD>
<TD><INPUT TYPE='TEXT' NAME='errornum' VALUE='' width=4 maxlength=4></TD>
</TR><br>
<TR>
<TD>Description</TD>
<TD>
<INPUT TYPE='TEXT' NAME='description' VALUE='' width=255>
</TD>
</TR>
<TR>
<TD></TD><br>
<TD><INPUT TYPE="submit" name="add" value="Add Error"></TD>
</TR>
</TABLE>
</form>
