Database Error: 1064 |
[eluser]Unknown[/eluser]
Well hoping I can get some help, I've searched forums and googled this any way I can think of but haven't found a solution. I have installed XMAMPP: XAMPP 1.7.3, including: Apache 2.2.14 (IPv6 enabled) + OpenSSL 0.9.8l MySQL 5.1.41 + PBXT engine PHP 5.3.1 phpMyAdmin 3.2.4 Perl 5.10.1 FileZilla FTP Server 0.9.33 Mercury Mail Transport System 4.72 I have also downloaded and have running CODEIGNITER 1.72. I have my basic application up and connecting to my database. I had a custom sql I have written to select data that instead of using the active record pattern. I can run this query directly on the DB and get results back but when I run from my code i'm getting Error Number: 1064. Below is the details echo'd out on the error. I'm also include the code function that has the db call. ERROR Message: Quote:A Database Error Occurred CODE BLOCK: Code: function index() {
[eluser]danmontgomery[/eluser]
[quote author="Eric Mahaffey" date="1277497088"]Well hoping I can get some help, I've searched forums and googled this any way I can think of but haven't found a solution.[/quote] Have you tried the user guide? http://ellislab.com/codeigniter/user-gui...eries.html Code: $data['query'] = $this->db->get($sql); Code: $data['query'] = $this->db->query($sql);
[eluser]Unknown[/eluser]
Thanks for the help, I completely missed changing that when I decided not to use the active record approach. Thanks again, Eric |
Welcome Guest, Not a member yet? Register Sign In |