add up a collum
Posted: Tue Jul 25, 2006 4:00 pm
i cant figure out how to add all the data up on one row.
im using mysql and made a file uploading script it will upload and then record all the file that are uploaded
here is the sql
im using mysql and made a file uploading script it will upload and then record all the file that are uploaded
here is the sql
now i want to set a limit for the 10mb for there file but i need to code that will add up all the file size on the columthat were uploaded so i can state they have the number of mb leftCHANGE `user` `user` VARCHAR( 100 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
CHANGE `filetype` `filetype` VARCHAR( 100 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
CHANGE `filesize` `filesize` VARCHAR( 100 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
CHANGE `filename` `filename` VARCHAR( 100 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
CHANGE `dateuploaded` `dateuploaded` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP