Jump to content


Photo

very strange problem with sum() function


  • Please log in to reply
1 reply to this topic

#1 pelegk2

pelegk2
  • Members
  • PipPip
  • Member
  • 11 posts
  • LocationIsrael

Posted 18 December 2003 - 08:19 AM

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
?>[/code]
Israel the best place to live in fter Heaven

#2 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 18 December 2003 - 04:40 PM

Try it this way

SELECT SUM(val) as xx from mydata

You shouldn\'t use the quotes.
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users