Brennen hippopotomonstrosesquipedaliophobia Nov 6, 2011 291 36 Dec 25, 2011 #1 Can I use a mysql query to set all the items with page id 105 to amount 50 and price 1? Please reply asap!
Can I use a mysql query to set all the items with page id 105 to amount 50 and price 1? Please reply asap!
xStefan Active Member Dec 11, 2011 93 29 Dec 25, 2011 #2 UPDATE furniture SET page = 10 & price = 1; Upvote 0 Downvote
Brennen hippopotomonstrosesquipedaliophobia Nov 6, 2011 291 36 Dec 25, 2011 Thread starter #3 That wont work lmao, sorry but I know it wont, for 1 its page_id and its 105 and what about the amount? Upvote 0 Downvote
That wont work lmao, sorry but I know it wont, for 1 its page_id and its 105 and what about the amount?
xStefan Active Member Dec 11, 2011 93 29 Dec 25, 2011 #4 simply change the words page_id = & amount = its just rearranging the words. Upvote 0 Downvote
Sojobo Member Nov 26, 2010 79 82 Dec 25, 2011 #5 UPDATE catalog_items SET page_id = 10, cost_credits = 1; Upvote 0 Downvote
Brennen hippopotomonstrosesquipedaliophobia Nov 6, 2011 291 36 Dec 25, 2011 Thread starter #6 No I need to set ALL the items IN page ID 105 to amount 10 and price 1, or is that what that does? Upvote 0 Downvote
Brennen hippopotomonstrosesquipedaliophobia Nov 6, 2011 291 36 Dec 25, 2011 Thread starter #7 UPDATE catalog_items SET amount = 100, cost_credits = 1 WHERE page_id = 105; That worked Upvote 0 Downvote
