i don't want form or any thing i want that user get active by admin, when admin visit player-update.php it update all user
here is code i am using
Expand|Select|Wrap|Line Numbers
- $query = "SELECT join_survivor.join_user, join_survivor.join_pool, join_survivor.join_done, join_survivor.join_fight, events_fights.event_id, join_survivor.join_event, events_fights.fight_id, join_survivor.join_win, join_survivor.join_lost, events_fights.win, events_fights.lost, survivor_events.event_id, survivor_events.event_period, join_survivor.join_pick ".
- "FROM join_survivor, events_fights, survivor_events ".
- "WHERE join_survivor.join_pick = '1' AND join_survivor.join_done = '0' AND events_fights.event_id = join_survivor.join_event AND join_survivor.join_event = survivor_events.event_id AND survivor_events.event_period = 'past' AND join_survivor.join_win = events_fights.lost AND join_survivor.join_fight = events_fights.fight_id";
- $result = mysql_query($query) or die(mysql_error());
- while($row = mysql_fetch_array($result))
- {
- mysql_query(" UPDATE join_survivor SET join_done ='1', join_pick='0' WHERE join_done = '0' AND join_pick = '1' AND event_period = 'past'");
- mysql_query($query) or die ('Same entry please go back');
- }
the problem is this when join_survivor.join_win = events_fights.lost it update whole table, i want that it only update that user only please help me out, if u don't understand let me know, because i have really bad english
thanks in advance