SQL Select statement using array values

Question

I need to SELECT based on the values in one of my array key fields.

I have seen a few similar questions which were answered using a join but this didn't quite work for me.

Here's what I have so far;

$sku = join("','", $itemrow["SellerSKU"]);
$item_id =("SELECT PRODUCT_ID FROM ".DB_PRODUCTS." WHERE PRODUCT_CODE = ($sku);");

The error I'm getting is:

Warning: join(): Invalid arguments passed

SOLVED:: In addition to the accepted answer this also worked;

I also managed this by re-jigging the statement and concatenating the variable; ("SELECT PRODUCT_ID FROM ".DB_PRODUCTS." WHERE PRODUCT_CODE = ".$itemrow["SellerSKU"].";

What is it you are trying to achieve?

DevlshOne
– DevlshOne

2013-08-16 11:05:43 +00:00
Commented Aug 16, 2013 at 11:05 — DevlshOne
– DevlshOne, Commented Aug 16, 2013 at 11:05

Sahil Mittal · Accepted Answer · 2013-08-16 11:15:33Z

1

Instead, you IN and implode

Try this-

$query= "SELECT PRODUCT_ID FROM ".DB_PRODUCTS." WHERE PRODUCT_CODE IN (" . implode(',', $itemrow["SellerSKU"]) . ")";

edited Aug 16, 2013 at 11:15

answered Aug 16, 2013 at 11:05

Sahil Mittal

20.7k12 gold badges68 silver badges91 bronze badges

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

2 Comments

hjpotter92 Over a year ago

"...IN (" . implode(',', $itemrow["SellerSKU"]) . ")";

Philip Richardson Over a year ago

Worked using hjpotter92's solution! Will accept as soon as I can.

Farid Movsumov · Accepted Answer · 2013-08-16 11:15:35Z

1

$sku = implode(",", $itemrow["SellerSKU"]);
$item_id =("SELECT PRODUCT_ID FROM ".DB_PRODUCTS." WHERE PRODUCT_CODE in ($sku);");

answered Aug 16, 2013 at 11:15

Farid Movsumov

12.8k8 gold badges74 silver badges98 bronze badges

Collectives™ on Stack Overflow

SQL Select statement using array values

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related