I get an error that I have a parse error on line 10?
<?php
mysql_connect(localhost,root,"");
mysql_select_db(prerentdb) or die( "Unable to select database");
if(!empty($_POST["submit"]))
{
$apt = $_POST['apt'];
$query="SELECT * FROM payments Where apt='$apt'";
$result=mysql_query($query);
if(mysql_num_rows($result))
}
{
$sql = "UPDATE payments SET
amtpaid = '0', prevbal = '0', tentpay = '0', datepaid = ' ', late = ' ', paidsum = '0'
WHERE paidsum = rentdue OR late = 'L'";
mysql_query($sql) or die("Update query failed.");
echo "Records have been updated";
}
?>
You have an if statement with no braces.
<?php
mysql_connect(localhost,root,"");
mysql_select_db(prerentdb) or die( "Unable to select database");
if(!empty($_POST["submit"]))
{
$apt = $_POST['apt'];
$query="SELECT * FROM payments Where apt='$apt'";
$result=mysql_query($query);
if(mysql_num_rows($result)) {
}
}
{
$sql = "UPDATE payments SET
amtpaid = '0', prevbal = '0', tentpay = '0', datepaid = ' ', late = ' ', paidsum = '0'
WHERE paidsum = rentdue OR late = 'L'";
mysql_query($sql) or die("Update query failed.");
echo "Records have been updated";
}
?>
Or maybe you have one closing brace too many:
if(mysql_num_rows($result))
[B][COLOR="Red"][SIZE="3"]}[/SIZE][/COLOR][/B]
{