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 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. 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 Link to comment https://forums.phpfreaks.com/topic/9159-query-failing-need-help/#findComment-33894 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.