sk121506 Posted January 17, 2008 Share Posted January 17, 2008 $query = "UPDATE ('$keyarray['item_name'.$i]')||'_'||('$keyarray['option_selection2_'.$i]') SET AdvertiserID=('$_SESSION['username']') WHERE AdvertiserID='0' AND Day=('$keyarray['option_selection1_'.$i]') AND ('$keyarray['option_selection2_'.$i])_Id=('$randNums')"; ($randNums is an array) in english after all the paypal variables pass through i would like it to read... UPDATE January_Ad1 SET AdvertiserID=(the user logged in) WHERE AdvertiserID='0' AND Day=1 AND Ad1_Id=(the random numbers that were generated before the query) Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/86515-whats-wrong-with-this-query/ Share on other sites More sharing options...
fenway Posted January 17, 2008 Share Posted January 17, 2008 Random numbers? Plural? What's the error? Quote Link to comment https://forums.phpfreaks.com/topic/86515-whats-wrong-with-this-query/#findComment-442068 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.