Welcome Guest, Not a member yet? Register   Sign In
SQL query errors in Code Ignitor but runs fine in PhpMyAdmin & Navicat

[eluser]morph london[/eluser]
I have the following database error, but when I copy the the query in the error into Navicat or PhpMyAdmin it executes correctly. Seems strange.

A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; SELECT `events_type`.`type`, `events_type`.`title` as type_title, `events`.`' at line 1

SET @rank=0; SELECT `events_type`.`type`, `events_type`.`title` as type_title, `events`.`title`, `events`.`id`, `events`.`content`, `events`.`date`, `events`.`price`, `events`.`permalink`, `events`.`finish`, `events`.`hasfinish`, `events`.`venue`, `events`.`rank`, `events`.`abstract`, `events`.`buylink` FROM (SELECT *,@rank := @rank + 1 AS rank FROM events ORDER BY DATE ASC) AS `events` Inner Join `events_type` ON `events`.`events_type_id` = `events_type`.`id` WHERE `events`.`status` = 1 AND `events`.`date` >= '2008-10-02 19:01:00' AND (`events`.`age` = 10 OR `events`.`age` = 17 OR `events`.`age` = 19) ORDER BY date ASC LIMIT 3

Theme © iAndrew 2016 - Forum software by © MyBB