Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
pelegk2
Forum Regular
Posts: 633 Joined: Thu Nov 27, 2003 5:02 am
Location: Israel - the best place to live in after heaven
Contact:
Post
by pelegk2 » Thu Dec 18, 2003 1:23 am
i am doing
SELECT SUM('val') as xx from mydata
where val is of type float
even when i do this on mySql i get 0 as the total value!!!!
why?
(i dont have negative numbers
thanks in advance
peleg
?>
oQEDo
Forum Commoner
Posts: 43 Joined: Thu Feb 20, 2003 11:08 am
Location: UK
Post
by oQEDo » Thu Dec 18, 2003 5:15 am
Try SELECT SUM(val) as xx from mydata (i.e. miss out the ' )
pelegk2
Forum Regular
Posts: 633 Joined: Thu Nov 27, 2003 5:02 am
Location: Israel - the best place to live in after heaven
Contact:
Post
by pelegk2 » Thu Dec 18, 2003 5:34 am
thanks it worked:)