How are you building 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 Me
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-DB] nysql_query confusing selects for inserts?
>
>
> Yes, I copied it verbatium and copie
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 [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 03, 2002 1
cause you typed 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 in
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 = mysql_query("
