Hello all, I have this one record database file used to hold several last used values, I've confirmed validity of the record. I don't get an error so ....? Will someone take look at this feeble attempt and advise?
thanks in advance!
PHP Code:
<?php
// error_reporting(0);
error_reporting(E_ALL ^ E_NOTICE);
mysql_connect("localhost","root","");
mysql_select_db("numbersdb") or die( "Unable to select database");
if(!empty($_POST["submit"]))
{
$taxrate = $_POST['taxrate'];
$query="SELECT * FROM numbdata Where id='$id'";
$result=mysql_query($query);
if(mysql_num_rows($result))
{
}else{echo "No listing for taxrate $taxrate .<br />Select another? .<br />";}
}
if(!empty($_POST["update"]))
{
$sql = "UPDATE numbdata SET
taxrate = '" .mysql_real_escape_string($_POST['taxrate']) . "',
WHERE taxrate='".$_POST['taxrate']."'";
mysql_query($sql) or die(mysql_error());
echo "Record for taxrate ".$_POST["taxrate"]." has been updated";
}
?>
trying to update
