Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
August 21, 2007, 12:02 pm
rate this thread
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!!
Re: wrong summation using php to read mysql database
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
JDS Computer Training Corp.
- » Newbie: MySql is loaded when PHP runs from command line, but not through IIS
- — Previous thread in » PHP Scripting Forum