Dear Sir/ Madam,

I am getting error message while trying to checking field using operators in active field (page-83). I have tried in different way but failed,

shows "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 '`!=` '6' ORDER BY `category_id` desc LIMIT 100' at line 4

SELECT `id`, `name`, `thumbnail`, `category_id` FROM (`products`) WHERE `status` = 'active' AND `id` `!=` '6' ORDER BY `category_id` desc LIMIT 100".

Can anyone help me ?

Thanks in advance
Jobayer

Greetings,

If the string your using is the one above then you should not have != wrapped in back ticks, single or double quotes.

Dear Sir,

Thanks for your message. I have used db->where('id !=', '6') then it produces this query. Can you please suggest me how can I use operators for checking (I want to check where id!=6)?

Thanks in advance
Jobayer

Even though you are pointing to page 83, please post the code you have used, and the version of MySQL you are using.

There are several ways to debug this.

You can also try $this->db->query(PUT QUERY HERE) and see if that returns what is expected. If that works, then go back to $this->db->where and use <> instead of !=

Thanks for your feedback. Actually when I have found error for the first time, I have managed it using direct sql query.

I want to use operator for it and failed in every way. I have used <> too, but I have found same error message. I am using MySQL version 5.0.45. Can you please specify the MySQL Version ?

Thanks
Jobayer

Please post your actual code, not just the single line, and let me know what else you have tried. My version of MySQL is 5.5.16 but that should not be an issue.

Did you change any settings in the site config, sql or php?

This is my final code:
Where you are using this:
Did you try this:
Notice there are no quotes around the number 6

Let me know what happens.

Paul

Dear Sir,

I have used this below code:

function getRandomProducts($limit,$skip){
$data = array();
$temp = array();
if($limit == 0){
//echo $limit;
$limit=3;
}

//$sql = "select id,name,thumbnail,category_id from products where status='active' and id <> '$skip' order by category_id asc limit 100";

//$Q = $this->db->query($sql);

/*$this->db->select("id,name,thumbnail,category_id");

$array = array('id <>' => $skip, 'status' => 'active');
$this->db->where($array); */

$this->db->where('status', 'active');
$this->db->where('id !=', $skip);
$this->db->order_by("category_id", "desc");
$this->db->limit(100);
$Q = $this->db->get('products');

if ($Q->num_rows() > 0){
foreach($Q->result_array() as $row){

$temp[$row['category_id']] = array(
"id" => $row['id'],
"name" => $row['name'],
"thumbnail" => $row['thumbnail']
);
}
}

and it produces this message:

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 '`!=` '7' ORDER BY `category_id` desc LIMIT 100' at line 4

SELECT * FROM (`products`) WHERE `status` = 'active' AND `id` `!=` '7' ORDER BY `category_id` desc LIMIT 100

Filename: C:\wamp\www\CodeIgniter_2.1.1\system\database\DB_d river.php

Line Number: 330

I have also tried it using db->where('id !=', 6), but found error message. Please let me know what's wrong with it.

Thanks
Jobayer

I noticed you had the select statement commented out. Did you un-comment that and try again?

Yes, I have mentioned it in my previous reply. I have managed my program to run properly using the commented code, it's nothing but a straight sql query.

I want to run it using operators and using codeignitor's convention like the above code, if there is any solution. Otherwise, I will use straight sql query like above commented code.

Let me know your opinion.

Thanks
Jobayer