This is extremely annoying. For some reason, mysql_query seems to be
confusing my left join for an insert or update. The reason being, that the
query runs fine, but the result isn't usable. Here's the example code. Table
definitions are below if that helps.
$err = 0;
// $result =
it into the MYSQL command line,
then it must be correct?
-Original Message-
From: Ken Kinder [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 12:08 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] nysql_query confusing selects for inserts?
This is extremely annoying. For some
lead
left join lead_support_1 on lead.lead_support_id = lead_support_1_id
But rather, it was in one log string.
-Original Message-
From: Ken Kinder [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 12:33 PM
To: Rick Emery; [EMAIL PROTECTED]
Subject: Re: [PHP
not
look like:
select
lead.lead_id,
lead.firstname,
lead.lastname,
lead_support_1.plusfour
from
lead
left join lead_support_1 on lead.lead_support_id = lead_support_1_id
But rather, it was in one log string.
-Original Message-
From: Ken Kinder
the SELECT statement. I would have thought it'd be:
$query = select lead.lead_id, lead.firstname, lead.lastname,
lead_support_1.plusfour from lead left join lead_support_1 on
lead.lead_support_id = lead_support_1_id
-Original Message-
From: Ken Kinder [mailto:[EMAIL PROTECTED]]
Sent