Re: Subject: SQL Statement

"Neil Smith [MVP, Digital media]" <php@xxxxxxxxxxxxxxxxxxxxxxxx> · Wed, 19 May 2004 20:55:07 +0100

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.

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