Having a brain block - adding numbers from database

[herghost]

Hi all,

 

for some reason I cant see this blantantly obvious query.

 

I have 3 rows in my database, all with an id of 1, their is a column called price which contains three different float values, how the hell do I write a query in php for this?!

$q = mysql_query("SELECT price FROM mytable WHERE id=1")
????

Thanks!

[Pikachu2000]

You forgot to mention what this query should do exactly. Should it return the total, echo them each individually, or what?

[herghost]

Sorry, having a forgetful evening!

 

I want all the totals added together and then displayed, basically a total price

[Pikachu2000]

Try

"SELECT SUM(price) FROM mytable WHERE id=1"

[ManiacDan]

First of all, you're not writing a query in PHP, you're writing it in SQL.  New programmers don't usually understand that they're using up to 5 languages at once.  PHP, SQL, JavaScript, HTML, and Regular Expressions are all stand-alone languages.

 

Secondly, bah, pikachu beat me.

 

-Dan