Hi Peeps... I'm back !!
Right now I know this may sound dumb to most of you, but in the script below is a simple search on my database.
On first run it outputs everything in the tables. oooh!
How ever what I need it to do is to add up each of the colums in the tables if there is a number there to add up.
Fields to add up are g3, plus the result of g3 times by 0.175 and the result of g3 times 1.175
If the amount I have entered in the database in field g3 is 100.
And another amount is 50 in another line, then this would be the result...
VAT = 17.5% | Result: 2005-04-01, Fuel £117.50 VAT WAS 17.50 ON 100.00
VAT = 17.5% | Result: 2005-04-03, Fuel £58.75 VAT WAS 8.75 ON 50.00
TOTAL VAT = £26.25 TOTAL EX = £150 TOTAL INC = £176.25
Here is the table dump!
CREATE TABLE `calcs` (
`g1` date NOT NULL default '0000-00-00',
`g2` varchar(255) NOT NULL default '',
`g3` varchar(255) NOT NULL default '',
`g4` varchar(255) NOT NULL default '',
`g5` varchar(255) NOT NULL default '',
`id` int(11) NOT NULL auto_increment,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=86 ;
--
-- Dumping data for table `calcs`
--
INSERT INTO `calcs` VALUES ('2005-04-01', 'Fuel', '8.51', '17.5', 'a', 9);
INSERT INTO `calcs` VALUES ('2005-04-03', 'Fuel', '33.71', '17.5', 'a', 15);
INSERT INTO `calcs` VALUES ('2005-04-01', 'Paper + Punch Pocket', '7.19', '17.5', 'a', 13);
INSERT INTO `calcs` VALUES ('2005-04-05', 'Fuel', '28.43', '17.5', 'f', 16);
INSERT INTO `calcs` VALUES ('2005-04-07', 'Envelopes', '2.94', '0.00', '', 17);
INSERT INTO `calcs` VALUES ('2005-04-07', 'Stamps', '2.52', '0.00', '', 18);
INSERT INTO `calcs` VALUES ('2005-04-08', 'Stamps', '0.30', '0.00', '', 19);
INSERT INTO `calcs` VALUES ('2005-04-11', 'Fuel', '34.43', '17.5', '', 20);
INSERT INTO `calcs` VALUES ('2005-04-11', 'Food', '2.54', '17.5', '', 21);
INSERT INTO `calcs` VALUES ('2005-04-11', 'Fuel', '34.19', '17.5', '', 22);
INSERT INTO `calcs` VALUES ('2005-04-11', 'Drinks', '2.35', '0.00', '', 23);
INSERT INTO `calcs` VALUES ('2005-04-11', 'Food', '3.39', '17.5', '', 24);
INSERT INTO `calcs` VALUES ('2005-04-12', 'Fuel', '29.56', '17.5', '', 25);
INSERT INTO `calcs` VALUES ('2005-04-12', 'Food', '3.39', '17.5', '', 26);
INSERT INTO `calcs` VALUES ('2005-04-14', 'Stamps', '3.73', '0.00', '', 27);
INSERT INTO `calcs` VALUES ('2005-04-14', 'Fuel', '35.84', '17.5', '', 28);
INSERT INTO `calcs` VALUES ('2005-04-14', 'Food', '3.39', '17.5', '', 29);
INSERT INTO `calcs` VALUES ('2005-04-16', 'PC Repairs', '50.00', '0.00', '', 30);
INSERT INTO `calcs` VALUES ('2005-04-18', 'Phone Bill', '191.67', '0.00', '', 31);
INSERT INTO `calcs` VALUES ('2005-04-18', 'Food', '1.99', '0.00', '', 32);
INSERT INTO `calcs` VALUES ('2005-04-19', 'Stamps', '0.92', '0.00', '', 33);
INSERT INTO `calcs` VALUES ('2005-04-20', 'DM Club Switch Board', '42.5600', '17.5', '', 34);
INSERT INTO `calcs` VALUES ('2005-04-21', 'Fuel', '35.09', '17.5', '', 35);
INSERT INTO `calcs` VALUES ('2005-04-22', 'Fuel', '25.37', '17.5', '', 36);
INSERT INTO `calcs` VALUES ('2005-04-22', 'Food', '3.15', '0.00', '', 37);
INSERT INTO `calcs` VALUES ('2005-04-26', 'Fuel', '33.19', '17.5', '', 38);
INSERT INTO `calcs` VALUES ('2005-04-26', 'M6 Toll', '2.55', '17.5', '', 39);
INSERT INTO `calcs` VALUES ('2005-04-27', 'Stamps', '3.08', '0.00', '', 40);
INSERT INTO `calcs` VALUES ('2005-04-28', 'Printer Ink+Floppy Disks', '51.93', '0.00', '', 42);
INSERT INTO `calcs` VALUES ('2005-04-28', 'Fuel', '30.64', '17.5', '', 43);
INSERT INTO `calcs` VALUES ('2005-04-29', 'Fuel', '28.00', '17.5', '', 44);
INSERT INTO `calcs` VALUES ('2005-05-03', 'Office Supplies', '4.03', '17.5', '', 45);
INSERT INTO `calcs` VALUES ('2005-04-25', 'Advertising - Google - Credit Card', '80.35', '0.00', '', 46);
INSERT INTO `calcs` VALUES ('2005-04-11', 'O2 Mobile Phones', '46.97', '0.00', '', 47);
INSERT INTO `calcs` VALUES ('2005-04-11', 'Server Cost', '7.05', '0.00', '', 48);
INSERT INTO `calcs` VALUES ('2005-04-13', 'Congestion Charge London', '5.00', '0.00', '', 49);
INSERT INTO `calcs` VALUES ('2005-04-01', 'Congestion Charge London', '5.00', '0.00', '', 50);
INSERT INTO `calcs` VALUES ('2005-05-05', 'Stamps', '0.46', '0.00', '', 51);
INSERT INTO `calcs` VALUES ('2005-05-09', 'Stamps', '5.04', '0.00', '', 52);
INSERT INTO `calcs` VALUES ('2005-05-09', 'Office Supplies', '46.93', '17.5', '', 53);
INSERT INTO `calcs` VALUES ('2005-05-10', 'Stamps', '2.52', '0.00', '', 54);
INSERT INTO `calcs` VALUES ('2005-05-10', 'Fuel', '22.87', '17.5', '', 55);
INSERT INTO `calcs` VALUES ('2005-05-11', 'Drink', '1.61', '17.5', '', 56);
INSERT INTO `calcs` VALUES ('2005-05-11', 'Fuel', '24.06', '17.5', '', 57);
INSERT INTO `calcs` VALUES ('2005-05-11', 'Fuel', '32.15', '17.5', '', 58);
INSERT INTO `calcs` VALUES ('2005-05-12', 'Fuel', '29.51', '17.5', '', 59);
INSERT INTO `calcs` VALUES ('2005-05-13', 'SMS Messages - ITAGG', '50.00', '17.5', '', 60);
INSERT INTO `calcs` VALUES ('2005-05-03', 'Vehicle Repairs - Servicing', '179.76', '17.5', '', 61);
INSERT INTO `calcs` VALUES ('2005-05-13', 'Internet + Phone', '146.12', '0.00', '', 62);
INSERT INTO `calcs` VALUES ('2005-05-13', 'Paper', '7.69', '0.00', '', 63);
INSERT INTO `calcs` VALUES ('2005-05-18', 'Stamps', '2.52', '0.00', '', 64);
INSERT INTO `calcs` VALUES ('2005-05-18', 'Stamps', '0.21', '0.00', '', 65);
INSERT INTO `calcs` VALUES ('2005-05-19', 'Stamps', '2.52', '0.00', '', 66);
INSERT INTO `calcs` VALUES ('2005-05-20', 'Fuel', '34.04', '17.5', '', 67);
INSERT INTO `calcs` VALUES ('2005-05-20', 'Food', '2.54', '17.5', '', 68);
INSERT INTO `calcs` VALUES ('2005-05-20', 'Fuel', '21.72', '17.5', '', 69);
INSERT INTO `calcs` VALUES ('2005-05-22', 'Fuel', '37.90', '17.5', '', 70);
INSERT INTO `calcs` VALUES ('2005-05-24', 'Note Books', '0.96', '0.00', '', 71);
INSERT INTO `calcs` VALUES ('2005-05-20', 'Food', '3.65', '17.5', '', 72);
INSERT INTO `calcs` VALUES ('2005-05-31', 'O2 Business Mobiles', '64.85', '17.5', '', 73);
INSERT INTO `calcs` VALUES ('2005-06-01', 'Fuel', '37.77', '17.5', '', 74);
INSERT INTO `calcs` VALUES ('2005-06-03', 'Web Hosting', '99.99', '17.5', '', 75);
INSERT INTO `calcs` VALUES ('2005-06-09', 'Fuel', '31.53', '17.5', '', 76);
INSERT INTO `calcs` VALUES ('2005-06-09', 'Fuel', '31.46', '17.5', '', 77);
INSERT INTO `calcs` VALUES ('2005-06-10', 'Domain Name', '15.00', '17.5', '', 78);
INSERT INTO `calcs` VALUES ('2005-06-01', 'Stamps', '2.52', '0.00', '', 79);
INSERT INTO `calcs` VALUES ('2005-06-13', 'Vehicle Repairs - Tyres', '129.30', '17.5', '', 80);
INSERT INTO `calcs` VALUES ('2005-06-13', 'Internet + Phone', '112.10', '0.00', '', 81);
INSERT INTO `calcs` VALUES ('2005-06-14', 'Stamps', '5.87', '0.00', '', 82);
INSERT INTO `calcs` VALUES ('2005-06-23', 'DM Switchboard - Phone', '50.00', '0.00', '', 83);
INSERT INTO `calcs` VALUES ('2005-06-24', 'Google Advertising', '180.25', '21.00', 'Advertising', 84);
INSERT INTO `calcs` VALUES ('2005-06-24', 'Fuel', '4.27', '17.5', 'F', 85);
Here is the Script !
<?php
//define database
$dbhost="localhost";
$dbusername="****";
$dbpassword="****";
$dbname="ebay";
$db = mysql_connect($dbhost, $dbusername, $dbpassword);
mysql_select_db($dbname,$db);
// The form: LINE 10
?>
<form method="POST" action="">
Search Word: <input type="text" name="query">
Date: <input type="text" name="querydate">
<input type="SUBMIT" value="Search!">
</form>
<?
// PHP Search Script
$result = mysql_query("select * from calcs WHERE g5 LIKE '%$query%' AND g1 LIKE '%$querydate%'", $db);
while(list($g2, $g1, $g3, $g4)=mysql_fetch_array($result)){
echo "VAT = $g4% | Result: $g2, $g1 £";
if ($g4 == "0.00") {
$vat = $g3;
echo round($vat, 2);
echo "<br>";
} else {
if ($g4 == "17.5")
$showvat = $g3 * 0.175;
$g4 = "1.175";
$vat = $g3 * $g4;
echo round($vat, 2);
echo "<b> VAT WAS ";
echo round($showvat,2);
echo"</b>";
echo " ON $g3";
echo "<br>";
}
echo "</table>";
}
?>
😃 😃
If anyone can make these add up like they should I'll come round and make you a nice .... (er.. cup of tea!!!) 🙂
