----- Original Message ----- From: "Jeroen Timmers" <[EMAIL PROTECTED]> To: "Kunden Admin" <[EMAIL PROTECTED]> Sent: Friday, February 08, 2002 1:04 PM Subject: Re: [PHP-DB] Simple Question, hopefully simple answer
> > ----- Original Message ----- > From: "Kunden Admin" <[EMAIL PROTECTED]> > To: "Jeroen Timmers" <[EMAIL PROTECTED]> > Sent: Monday, October 08, 2001 11:49 AM > Subject: Re: [PHP-DB] Simple Question, hopefully simple answer > > > > I always seem to get the value "Resource id#2" as output when I use the > > following code... > > > > { > > $result = mysql_query("SELECT SUM(ACCTSESSIONTIME) AS TOTAL FROM > ACCOUNTING > > where FROM_UNIXTIME(TIME_STAMP,'%d.%m.%Y')='$filter'"); > > } > > echo $result; > > you must fetch the result > > while($row = mysql_fetch_array($result)) > echo $row[0]; > > /*or echo $row[total];*/ > > Jeroen > > > > > any help is much apreciated! > > > > Luke > > ----- Original Message ----- > > From: "Jeroen Timmers" <[EMAIL PROTECTED]> > > Newsgroups: php.db > > To: "Luke" <[EMAIL PROTECTED]> > > Cc: "[PHP-DB]" <[EMAIL PROTECTED]> > > Sent: Friday, February 08, 2002 1:36 PM > > Subject: Re: [PHP-DB] Simple Question, hopefully simple answer > > > > > > > > > > ----- Original Message ----- > > > From: "Luke" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Monday, October 08, 2001 10:52 AM > > > Subject: [PHP-DB] Simple Question, hopefully simple answer > > > > > > > > > > In one of my mySql tables I have a colum that contains many fields of > > > > numbers. > > > > for example > > > > > > > > ------------------------ > > > > | id | Name | Age | Sex | > > > > ------------------------ > > > > |1 | Jim | 17 | m | > > > > |2 | Dave | 31 | f | > > > > |3 | Fred | 25 | m | > > > > > > > > Ok and I want to get the total value of all the ages out of the table. > > how > > > > can I get this? > > > > > > mysql_query(select sum(age) as total from table); > > > > > > maybey you need after the from table the follow rule: > > > distinc by id. > > > > > > it is not tested. > > > > > > success > > > > > > Jeroen > > > > > > > > > > > Hope someone can help. > > > > > > > > Luke > > > > > > > > > > > > > > > > -- > > > > PHP Database Mailing List (http://www.php.net/) > > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > > > > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php