You are here: Re: wrong summation using php to read mysql database « PHP Programming Language « IT news, forums, messages
Re: wrong summation using php to read mysql database

Posted by Jerry Stuckle on 08/21/07 12:23

Asembereng wrote:
> want to read from a database using php commands and grouping by
> timetype jobdatefrom endyear and nctype and summing the groups for
> everymonth but instead it sums up for all the months. Here are the
> Codes i wrote for that:
>
>
> $query = mysql_query("select distinct sum(ChargeTime) as ChargeTime,
> sum(Amount) as AmounT , ClientName,
> JobDateFrom,JobDateTo,endYear,NcType from jobs where TimeType=0 group
> by TimeType, JobDateFrom, endYear, NcType having
> JobDateFrom>=Date('$startdate') and JobDateTo=('$enddate')");
>
>
>
> thats the query i am using. Can anyone help me on this?? Its an urgent
> matter. thank you!!
>

Since you're asking how to compose a SQL query, I suggest you try a SQL
newsgroup - like comp.databases.mysql.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация