Please answer to list next time.
Good. Now, what is your "Elecremain", "Controlremain", "otherremain"?
How should they be calculated...
P.S.: Why don't you give a try to some numerical data types? ;) To use
varchar everythere isn't a right way I think.
Brian E Boothe wrote:
my database structure SQL dump
# phpMyAdmin SQL Dump
# version 2.5.7-pl1
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Apr 14, 2006 at 12:36 AM
# Server version: 4.0.20
# PHP Version: 4.4.2
#
# Database : `workorder`
#
# --------------------------------------------------------
#
# Table structure for table `orders`
#
CREATE TABLE `orders` (
`ordernumber` varchar(12) NOT NULL default '',
`companyname` varchar(12) NOT NULL default '',
`billingaddress` varchar(12) NOT NULL default '',
`City` varchar(12) NOT NULL default '',
`State` varchar(12) default NULL,
`Zip` varchar(12) NOT NULL default '',
`PhoneNumber` varchar(12) NOT NULL default '',
`FaxNumber` varchar(12) NOT NULL default '',
`WebPage` varchar(12) NOT NULL default '',
`EmailAddress` varchar(12) NOT NULL default '',
`Notes` varchar(23) NOT NULL default '',
`Customer` varchar(12) NOT NULL default '',
`Startdate` varchar(12) NOT NULL default '',
`Completedate` varchar(12) NOT NULL default '',
`Biddate` varchar(12) NOT NULL default '',
`Bidamount` varchar(12) NOT NULL default '',
`ElecProjCost` varchar(12) NOT NULL default '',
`ElecProjBill` varchar(12) NOT NULL default '',
`ElecRem` varchar(12) NOT NULL default '',
`CtrlProjCost` varchar(12) NOT NULL default '',
`CtrlProjBill` varchar(12) NOT NULL default '',
`CtrlProjrem` varchar(12) NOT NULL default '',
`OthrProjCost` varchar(12) NOT NULL default '',
`OthrProjBill` varchar(12) NOT NULL default '',
`OthrProjrem` varchar(12) NOT NULL default '',
`BondAm` varchar(7) NOT NULL default '',
`BondBill` varchar(7) NOT NULL default '',
`BondRem` varchar(7) NOT NULL default ''
) TYPE=MyISAM;
#
# Dumping data for table `orders`
#
INSERT INTO `orders` VALUES ('4132006', 'Siouxcity SS', '231 Way way',
'SiouxCity', 'IA', '51101', '712-278-2331', '', 'ssrw.com',
'[EMAIL PROTECTED]', 'efbebebeftrbbe', 'Siouxcity', '12/2/2006',
'2/5/2007', '2/4/2007', '123000', '234', '2', '232', '435', '23', '',
'345', '23', '', '345', '23', '');
INSERT INTO `orders` VALUES ('1232006', 'Sciouscenter', '124323wgwr',
'Siouxcenter', 'IA', '51101', '712-278-2331', '', '', '', 'this is a
test project', 'Sioux', '12/2/2006', '2/5/2007', '2/4/2007', '123000',
'543', '456', '87', '654', '345', '309', '765', '123', '642', '8760',
'234', '8526');
(-----------------------------------------------End
Dump------------------------------------------------------------------------)
Eugene Kosov wrote:
Hi, Brian!
First of all I think next time you should better attach your database
structure. It'll be much easier to understand your problem if you
will...
Maybe you're asking for something like this:
SELECT project_name, elecremain, controlremain, otherremain,
elecremain + controlremain + otherremain AS total FROM table_name;
Brian E Boothe wrote:
i have three Values in each row of my MySQL database, im needing to
sum them in the table as they are displayed per Row ?? how do i do
this ?
Projectname Elecremain Controlremain
otherremain <?php ?>
Project1 2300 1600
250 <?php (Sum) ?>
Project2 4300 600
150 <?php (Sum) ?>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
