Mysql select query nut running at all

Question

I have the following query:

$query = $this->db->query("SELECT * FROM so.KI WHERE ICCID IN ('$nabi') ") or die(mysql_error());

But I get the following error:

A Database Error Occurred

Error Number:

SELECT * FROM so.KI WHERE ICCID in 8993017100107912997,8993017100107913011,8993017100107913029,8993017100107913037,8993017100107913045

They so database is Oracle and the KI table has got 2700000 records.

any help is highly appreciated! I wonder why such error is showed up!

$nabi is an array of ICCIDs coming from interface! I even wrote ICCIDs manually in the `IN()` section, but it is showing the same error!! — M Reza Saberi, Jan 21 '14 at 10:29

score 1 · Answer 1 · answered Jan 21 '14 at 10:30

here 8993017100107912997,8993017100107913011,8993017100107913029,8993017100107913037,8993017100107913045 is diffrent ids so as per you had defin

"SELECT * FROM so.KI WHERE ICCID IN ('$nabi') " its contain all string in condition.

please try below. and also check DATAbase connection also.

"SELECT * FROM so.KI WHERE ICCID IN ($nabi) "

score 1 · Answer 2 · answered Jan 21 '14 at 11:12

1

when using in('$variable') it prints as ('a,b.c.d') while it should be in('a','b','c','d') you have to put quotation for each element inside in() clause

answered Jan 21 '14 at 11:12

aman formuli

11
1

Mysql select query nut running at all

2 Answers2