kruzayn Posted May 5, 2006 Share Posted May 5, 2006 [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 Quote Link to comment https://forums.phpfreaks.com/topic/9159-query-failing-need-help/ Share on other sites More sharing options...
ober Posted May 5, 2006 Share Posted May 5, 2006 Add single quotes around $sku. Quote Link to comment https://forums.phpfreaks.com/topic/9159-query-failing-need-help/#findComment-33753 Share on other sites More sharing options...
kruzayn Posted May 6, 2006 Author Share Posted May 6, 2006 [!--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 Quote Link to comment https://forums.phpfreaks.com/topic/9159-query-failing-need-help/#findComment-33894 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.