Re: Subject: SQL Statement

You're missing a closing quote at the end of the line, following the group by calls, it should end as , calls"; Since you are passing a string to PHP to hand off to the DB engine. Also, PHP function mysql_error($connection) is useful as this will return any errors generated by your database (if present). Cheers - Neil At 00:57 19/05/2004 +0000, you wrote:

        $sqlwrk .= " WHERE (pk_phone_number = " . $fk_phone”) AND (date BETWEEN “'$my_startdate'” AND “'$my_enddate'”)”;

$sqlwrk .= " GROUP BY pk_phone_reports, fk_ph_num, date, calls;

======================================================== CaptionKit http://www.captionkit.com : Production tools for accessible subtitled internet media, transcripts and searchable video. Supports Real Player, Quicktime and Windows Media Player. VideoChat with friends online, get Freshly Toasted every day at http://www.fresh-toast.net : NetMeeting solutions for a connected world.