Hi all you guru's.
Who could crack this once for me.
I want to add the totals of my records posted to a mysql database table. I can achieve this by using the += method, but I have to have it in a repeated region (dreamweaver). I know there is certainly a shorter method, please, anyone,, assist me in this.
Here is an example of the database table:
CREATE TABLE IF NOT EXISTS `sample` ( `pmtID` int(11) NOT NULL auto_increment, `AccNo` varchar(250) NOT NULL default '', `Description` varchar(250) NOT NULL default '', `Amount` decimal(9,2) default '0.00', PRIMARY KEY (`pmtID`) );
So after posting several entries to the database table above, I'd like to have to totals of all the entries of the Amount field.
Then, another Q ;-)
How do I count how many entries my table has? I don't want to simply read the ID recod, I'd like to have a method to know how many entries I have posted.
Please guys, and thanx for all the previous support!!!!!!