I have two tables that I'd like to join for a dataset of selected columns. I'm doing the following in a test script:
<?php
define("PATHDRASTICTOOLS", "");
include(PATHDRASTICTOOLS."Examplemysqlconfig2.php");
include(PATHDRASTICTOOLS."drasticSrcMySQL.class.php");
class mysrc extends drasticsrcmysql {
protected function select(){
$res = mysql_query("SELECT a.ID, a.Title, b.MPAARating FROM $this->table1 b INNER JOIN $this->table2 a" . $this->orderbystr, $this->conn) or die(mysql_error());
return ($res);
}
}
$options = array (
"add_allowed" => false,
"delete_allowed" => false,
"editablecols" => array ()
);
$src = new drasticSrcMySQL($server, $user, $pw, $db, $table, $options);
$src->select();
?>
The "Examplemysqlconfig2.php" file looks like:
<?php
$server="localhost";
$user="dump_nc_ui_149";
$pw="********";
$db="dump_nc_ui_149";
$table="movies";
$table1="alternate_movie_titles";
$table2="movies";
$GApiKey="<put here your Google Maps API Key>";
?>
When the script is executed, the server returns the following message:
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/dump/webapps/flickpocket/drasticSrcMySQL.class.php on line 68
Could not find primary or unique key
The table definitions in the database are:
CREATE TABLE `alternate_movie_titles` (
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`MovieID` int(10) unsigned NOT NULL,
`Title` varchar(200) NOT NULL,
PRIMARY KEY (`ID`),
KEY `IDX_MovieID` (`MovieID`),
KEY `IDX_Title` (`Title`)
) ENGINE=MyISAM AUTO_INCREMENT=1175 DEFAULT CHARSET=utf8;
and...
CREATE TABLE `movies` (
`ID` int(10) unsigned NOT NULL,
`Title` varchar(200) NOT NULL,
`MPAARating` varchar(45) NOT NULL,
`ReleaseDate` datetime NOT NULL,
PRIMARY KEY (`ID`),
KEY `IDX_Title` (`Title`),
KEY `IDX_MPAARating` (`MPAARating`),
KEY `IDX_ReleaseDate` (`ReleaseDate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Is it possible to do table joins with the DrasticTools grid component?
Thanks in advance for any information -
dmm
DMM - 2009-01-08 12:57:43
