Hi Jay,

you suggestion does not make any difference.

The problem is that @idsum seems to be destroyed for every row!

Is there any other access method on a query that works properly 
or do I have to live with different results of the very same 
query asked directly in MySQL and asked through PHP?


Am Montag den, 9. September 2002, um 15:04, schrieb Jay Blanchard:

> [snip]
> I would like to be able to sum up a collumns values already in
> MySQL. The following query will sum up all values of the column
> 'id':
> SELECT @idsum:=(IFNULL(@idsum, id)+id), id FROM yourtable;
> Now a question to the PHP/MySQL experienced: Why does this type
> of query not work in combination with PHP? I am using query
> above as $query and do the following standard procedure:
> [/snip]
> Good point! Now as to your question, try this...
> SELECT @idsum:=(IFNULL(@idsum, id)+id) AS idsum, id FROM yourtable;
> When you output your query info output the value as $row->idsum;
> HTH!
> Jay

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to