"Steve Fitzgerald" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I'm trying to display a summary list of calls with one attribute being
> CallType. I have CallType and CallTypeID defined in a table name
> The problem I am having is taking the output of CallID defined in calls
> having the script match the CallTypeID to the CallType.
> $display_calls_sql = "SELECT CallID,CallDateTime,CallSubject,CallStatus
> calls WHERE ContactID = $ContactID";
> $display_calltype_sql = "SELECT CallType FROM calltypes INNER JOIN calls
> calltypes.CallTypeID = calls.CallTypeID WHERE CallID = '$CallID'
."CallID, CallDateTime, CallSubject, CallStatus, CallType "
."calls INNER JOIN calltypes ON call.CallTypeID =
."ContactID = $ContactID";
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]