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 =
, January 03, 2002 12:08 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] nysql_query confusing selects for inserts?
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
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
, 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-DB] nysql_query confusing selects for inserts?
Yes, I copied it verbatium and copied it right from
-DB] nysql_query confusing selects for inserts?
Yes, I copied it verbatium and copied it right from the HTML source into
this
email.
On Thursday 03 January 2002 11:22 am, Rick Emery wrote:
Have you actually print out $sql before its execution then
copied-and-pasted it to the MYSQL command
[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 copied it right from the HTML source into
this
email.
On Thursday 03 January 2002 11:22 am
-
From: Ken Kinder [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 2:32 PM
To: Rick Emery; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] nysql_query confusing selects for inserts?
I saved the query to a file, did a diff, and it does have one difference:
there are DOS newlines in the string
: Thursday, January 03, 2002 2:32 PM
To: Rick Emery; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] nysql_query confusing selects for inserts?
I saved the query to a file, did a diff, and it does have one difference:
there are DOS newlines in the string. Could that do it? Do you know how to
strip those out