"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
calltypes.
> The problem I am having is taking the output of CallID defined in calls
and
> having the script match the CallTypeID to the CallType.
>
> $display_calls_sql = "SELECT CallID,CallDateTime,CallSubject,CallStatus
FROM
> calls WHERE ContactID = $ContactID";
>
> $display_calltype_sql = "SELECT CallType FROM calltypes INNER JOIN calls
ON
> calltypes.CallTypeID = calls.CallTypeID WHERE CallID = '$CallID'
> ";
$display_calls_sql =
"SELECT "
."CallID, CallDateTime, CallSubject, CallStatus, CallType "
."FROM "
."calls INNER JOIN calltypes ON call.CallTypeID =
calltypes.CallTypeID "
."WHERE "
."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]