Clause to add where value is in array query

Question

I have this piece of code which i use in order to get all the values inside a column And save them in an array.

$sektori="SELECT * FROM userss WHERE Username='".$_SESSION['user_name']."'" 
or die(mysql_error());  
$resektor = odbc_exec($connection, $sektori) or die(odbc_error());
while( $row = odbc_fetch_array($resektor) ) {
$ids_sektor = explode("/",$row['sektori']);
}

I need to add this condition here:

$strSQL = "SELECT formas.*, SMS_SERVISI.IDTICKET, SMS_SERVISI.MBYLLUR,SMS_SERVISI.time_added
FROM formas 
LEFT JOIN SMS_SERVISI ON formas.ID = SMS_SERVISI.IDTICKET WHERE formas.data_fillim >= '$yesterday' AND formas.data_fillim <= '$tomorrow' AND  sektori_pergjegjes IN ($ids_sektor) ORDER BY formas.id DESC";

It says i have a syntax error, but i don't know..maybe i'm doinf the wrong thing, help please.

Thanks in advance.

Where does it say there's a syntax error?

Mike
– Mike

2013-02-28 14:26:56 +00:00
Commented Feb 28, 2013 at 14:26 — Mike
– Mike, Commented Feb 28, 2013 at 14:26
it says: Invalid column name 'Array'

pyetjegoo
– pyetjegoo

2013-02-28 14:27:10 +00:00
Commented Feb 28, 2013 at 14:27 — pyetjegoo
– pyetjegoo, Commented Feb 28, 2013 at 14:27

MarcinJuraszek · Accepted Answer · 2013-02-28 14:50:10Z

2

Change your condition to that one:

"AND  sektori_pergjegjes IN ('" . implode('\',\'', $ids_sektor) . "')"

edited Feb 28, 2013 at 14:50

answered Feb 28, 2013 at 14:28

MarcinJuraszek

126k15 gold badges200 silver badges267 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

MarcinJuraszek Over a year ago

Show the query that is generated into $strSQL with my change

pyetjegoo Over a year ago

$strSQL = "SELECT formas.*, SMS_SERVISI.IDTICKET, SMS_SERVISI.MBYLLUR,SMS_SERVISI.time_added FROM formas LEFT JOIN SMS_SERVISI ON formas.ID = SMS_SERVISI.IDTICKET WHERE formas.data_fillim >= '$yesterday' AND formas.data_fillim <= '$tomorrow' AND sektori_pergjegjes IN (" + implode(',', $ids_sektor) + ") ORDER BY formas.id DESC";

MarcinJuraszek Over a year ago

OK, check now - replaced + with .

pyetjegoo Over a year ago

Please one question, so i echo it and i get this result SELECT formas.*, SMS_SERVISI.IDTICKET, SMS_SERVISI.MBYLLUR,SMS_SERVISI.time_added FROM formas LEFT JOIN SMS_SERVISI ON formas.ID = SMS_SERVISI.IDTICKET WHERE formas.data_fillim >= '20130227' AND formas.data_fillim <= '20130301' AND formas.sektori_pergjegjes IN (B) ORDER BY formas.id DESC

pyetjegoo Over a year ago

Finally :):) Thanks very much!

Collectives™ on Stack Overflow

Clause to add where value is in array query

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related