Jump to content

Archived

This topic is now archived and is closed to further replies.

kruzayn

Query Failing, need help

Recommended Posts

[code] //get product ID for just entered item

$sqlgetid= "select product_id from jos_vm_product where product_sku=$sku";
$productid=mysql_query($sqlgetid) or die ("FAILED2");[/code]

Can anyone tell my why this is failing?

I am entering items into a database, with product_id being automatically assigned. the line above this one works and enters them like needed into the DB, but this one fails. I need to store the product id (ex: 1567) in $productid.

Thanks for any help!

kruz

Share this post


Link to post
Share on other sites
Add single quotes around $sku.

Share this post


Link to post
Share on other sites
[!--quoteo(post=371723:date=May 5 2006, 05:09 PM:name=ober)--][div class=\'quotetop\']QUOTE(ober @ May 5 2006, 05:09 PM) [snapback]371723[/snapback][/div][div class=\'quotemain\'][!--quotec--]
Add single quotes around $sku.
[/quote]


i knew it was something stupid, had been at it for quite a few hours, ran it and that part failed.

Thanks!

kruzayn

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.