Severity: Notice
Message: Trying to get property of non-object
Filename: controllers/home.php
Line Number: 70
Severity: Notice
Message: Trying to get property of non-object
Filename: controllers/home.php
Line Number: 71
Severity: Notice
Message: Undefined variable: moviepos
Filename: models/home_model.php
Line Number: 187
Severity: Notice
Message: Undefined variable: moviepos
Filename: models/home_model.php
Line Number: 188
Severity: Notice
Message: Undefined variable: moviepos
Filename: models/home_model.php
Line Number: 189
Severity: Notice
Message: Undefined variable: moviepos
Filename: models/home_model.php
Line Number: 190
Severity: Notice
Message: Undefined variable: moviepos
Filename: models/home_model.php
Line Number: 191
Severity: Notice
Message: Undefined variable: moviepos
Filename: models/home_model.php
Line Number: 192
Severity: Notice
Message: Undefined variable: moviepos
Filename: models/home_model.php
Line Number: 193
Severity: Notice
Message: Undefined variable: moviepos
Filename: models/home_model.php
Line Number: 194
Severity: Notice
Message: Undefined variable: moviepos
Filename: models/home_model.php
Line Number: 195
Severity: Warning
Message: Cannot modify header information - headers already sent by (output started at /home/gearoidc/public_html/moviestwit.com/system/libraries/Exceptions.php:166)
Filename: codeigniter/Common.php
Line Number: 356
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 '-3, 7' at line 7
SELECT `tweets`.`mid`, `movies`.`id`, `movies`.`name`, AVG(`tweets`.`rate`) * Count(`tweets`.`rate`) As averate FROM (`tweets`) JOIN `movies` ON `movies`.`id` = `tweets`.`mid` WHERE `tweets`.`submit` = '1' GROUP BY `tweets`.`mid` ORDER BY `averate` desc LIMIT -3, 7