I just got a reply back from the php forum on plus net with a user confirming this:
Yep, the user you're running has not been granted select permissions.
Though looking at it is CourseTitle actually a table?
Try the following:-
Code:
my $sql = qq/SELECT * FROM coursesUnixLinux WHERE CourseTitle LIKE ( "%$keywordsearch%")/;
(The qq/ / forces quote delimiters around everything inside the / / marks avoiding the need to escape out quote marks etc...)
Table structure
Code: Select all
#
# Table structure for table `coursesUnixLinux`
#
CREATE TABLE `coursesUnixLinux` (
`RecordID` int(4) NOT NULL auto_increment,
`CourseTitle` varchar(255) binary NOT NULL default '',
`Duration` int(2) NOT NULL default '0',
`Price` int(6) NOT NULL default '0',
`January` varchar(12) binary default NULL,
`February` varchar(12) binary default NULL,
`March` varchar(12) binary default NULL,
`April` varchar(12) binary default NULL,
`May` varchar(12) binary default NULL,
`June` varchar(12) binary default NULL,
`July` varchar(12) binary default NULL,
`August` varchar(12) binary default NULL,
`September` varchar(12) binary default NULL,
`October` varchar(12) binary default NULL,
`November` varchar(12) binary default NULL,
`December` varchar(12) binary default NULL,
`Location` mediumtext NOT NULL,
PRIMARY KEY (`RecordID`),
UNIQUE KEY `RecordID` (`RecordID`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;
HTH
Frank
feyd | ..