Jhosef Posted August 1, 2012 Group: Members Topic Count: 98 Topics Per Day: 0.02 Content Count: 299 Reputation: 5 Joined: 04/05/12 Last Seen: September 9, 2012 Share Posted August 1, 2012 i want to request a sql i want to put this item to all account 20048 is the item id in there inventory using my database Quote Link to comment Share on other sites More sharing options...
Fluffle Puff Posted August 1, 2012 Group: Members Topic Count: 29 Topics Per Day: 0.01 Content Count: 375 Reputation: 88 Joined: 12/30/11 Last Seen: May 3, 2016 Share Posted August 1, 2012 INSERT INTO `inventory` (account_id, nameid, amount, identify) SELECT account_id, 20048, 1, 1 FROM login WHERE sex!='S' AND state=0; Quote Link to comment Share on other sites More sharing options...
Jhosef Posted August 2, 2012 Group: Members Topic Count: 98 Topics Per Day: 0.02 Content Count: 299 Reputation: 5 Joined: 04/05/12 Last Seen: September 9, 2012 Author Share Posted August 2, 2012 @alexandria the sql you made is not working i want in all Account will have in the inventory this Item 20048 20048 is the itemid not account_id Quote Link to comment Share on other sites More sharing options...
Question
Jhosef
i want to request a sql
i want to put this item to all account
20048 is the item id
in there inventory
using my database
Link to comment
Share on other sites
2 answers to this question
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.