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]
