⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

Mysql error with this specific table name

Started by lordlaw, 18 January 2016 - 07:29 AM

Single Page

lordlaw

Member

Posted 18 January 2016 - 07:29 AM

my code

$crud->set_relation('RoleTypeId', 'type_role', 'Title');

then i got this

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 ' type_role.Title as s4fe56881 FROM `type_role` ORDER BY `s4fe56881`' at line 1

SELECT type_role., type_role.Title as s4fe56881 FROM `type_role` ORDER BY `s4fe56881`

Filename: models/Grocery_crud_model.php

Line Number: 278

any advice?

Thanks

Amit Shah

Member

Posted 18 January 2016 - 20:52 PM

please paste the complete code ... it might be something else that may be causing the issue