Nothing was entered";
}
$query = mysql_query("INSERT INTO checkbook (date, number, subject, payee, withdrawal, deposit, balance)
VALUES ('$date', '$number', '$subject', '$payee', '$withdrawal', '$deposit', '$balance')")
or die (mysql_error());
}
?>
My Checkbook
home
| Entry |
Date |
Number |
Subject |
Payee |
Withdrawal |
Deposit |
Balance |
//Grab entriest to Checkbook
$query="SELECT * FROM checkbook ORDER BY entry";
$result=mysql_query($query);
$num=mysql_num_rows($result);
$i=0;
while ($i < $num) {
$entry=mysql_result($result,$i,"entry");
$date=mysql_result($result,$i,"date");
$number=mysql_result($result,$i,"number");
$subject=mysql_result($result,$i,"subject");
$payee=mysql_result($result,$i,"payee");
$withdrawal=mysql_result($result,$i,"withdrawal");
$deposit=mysql_result($result,$i,"deposit");
$balance=mysql_result($result,$i,"balance");
if ($z == 0) {
$class = "color1";
$z = 1;
} else {
$class = "color2";
$z = 0;
}
echo"
| $entry |
$date |
$number |
$subject |
$payee |
$withdrawal |
$deposit |
$$balance |
";
++$i;
}
?>