It does/did. I add this print statement:
$result = mysql_query($sql) || $err = 1;
print "<pre><b>$sql</b></pre>\n";
And it yields this:
<pre><b>select
lead.lead_id,
lead.firstname,
lead.lastname,
lead_support_1.area_code
from
lead
left join lead_support_1 on lead.lead_support_id = lead_support_1_id
</b></pre>
On Thursday 03 January 2002 11:40 am, Rick Emery wrote:
> So show us the print out when you printed $sql. I'm certain it did 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 [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, Rick Emery wrote:
> > Have you actually print out $sql before its execution then
> > copied-and-pasted it to the MYSQL command line.
> > Or are you assuming that because 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 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. Here's the example
> > code. Table
> >
> > definitions are below if that helps.
> >
> > $err = 0;
> > // $result = mysql_query("select * from lead");
> > $result = mysql_query($sql) || $err = 1;
> >
> > if ($err || !$result) {
> > print "<h3>SQL Error</h3>\n";
> > print "<pre>" . mysql_error() . "</pre>\n";
> > } else {
> > print "<h3>Result Sample</h3>\n";
> > print "<table border=0 cellpadding=2 cellspacing=2 class=entry>\n";
> > $c = 0;
> > while ($row = mysql_fetch_array($result)) {
> >
> > As you can see, I both check for $result being untrue, and I use the ||
> > operator to catch execution failures. $result seems to be simply equal to
> > 1.
> >
> > On the last line, I get:
> >
> > Warning: Supplied argument is not a valid MySQL result resource in
> > /home/ken/Projects/leadmgr/query_leads_step1.php on line 95
> >
> > But the query itself doesn't seem to fall, or the print "<h3>SQL
> > Error</h3>"
> >
> > would print.
> >
> > The query I'm trying is:
> >
> > 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
> >
> > which works fine on the MySQL command line. Here are the create
> > definitions:
> >
> > CREATE TABLE `lead` (
> > `lead_id` int(11) NOT NULL auto_increment,
> > `lead_import_id` int(11) NOT NULL default '0',
> > `lead_source_id` int(11) NOT NULL default '0',
> > `firstname` varchar(50) default NULL,
> > `lastname` varchar(50) default NULL,
> > `phone` varchar(35) default NULL,
> > `fax` varchar(35) default NULL,
> > `alt_phone` varchar(35) default NULL,
> > `address1` varchar(100) default NULL,
> > `address2` varchar(100) default NULL,
> > `city` varchar(100) default NULL,
> > `state` char(2) default NULL,
> > `zip` varchar(25) default NULL,
> > `country` varchar(50) default NULL,
> > `email` varchar(255) default NULL,
> > `other_unique_num` int(11) default NULL,
> > `lead_field_set_id` int(11) default NULL,
> > `lead_support_id` int(11) default NULL,
> > PRIMARY KEY (`lead_id`),
> > UNIQUE KEY `other_unique_num` (`other_unique_num`,`lead_source_id`)
> > ) TYPE=MyISAM
> >
> > Now for lead_support_1:
> >
> > CREATE TABLE `lead_support_1` (
> > `lead_support_1_id` int(11) NOT NULL auto_increment,
> > `purchase_value` float default NULL,
> > `mortgage_value` float default NULL,
> > `carrier_route` varchar(4) default NULL,
> > `condo_code` char(1) default NULL,
> > `publish_date` date default NULL,
> > `area_code` char(3) default NULL,
> > `grantee_name` varchar(26) default NULL,
> > `typedoc` char(1) default NULL,
> > `delivery_point` char(2) default NULL,
> > `check_digit` char(1) default NULL,
> > `sale_type` char(1) default NULL,
> > `loan_type` char(1) default NULL,
> > `rate_type` char(1) default NULL,
> > `plusfour` varchar(4) default NULL,
> > `sale_date` date default NULL,
> > `lender_name` varchar(25) default NULL,
> > `country_code` char(3) default NULL,
> > `record_type` char(1) default NULL,
> > `spouse_indicator` char(1) default NULL,
> > `client_key` varchar(4) default NULL,
> > `serial_number` varchar(8) default NULL,
> > `line_of_travel` varchar(6) default NULL,
> > `job_number` varchar(8) default NULL,
> > `y2k_publish_date` date default NULL,
> > `y2k_sale_date` date default NULL,
> > PRIMARY KEY (`lead_support_1_id`)
> > ) TYPE=MyISAM
> >
> > PHP Version: php-4.0.6-7 RPM with RH 7.2
> > MySQL Version: mysql Ver 11.15 Distrib 3.23.44, for pc-linux-gnu (i686)
--
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]
