Forum Index » PHP + MySQL » Adding 1 per minute
| Posted on Wednesday 5th November 20 at 07:05 AM | |
jambomb Junior Member |
Yeh i've done that and edited abit but still only works for some people and now the ones who actualy need it lol ?? :s |
| Posted on Thursday 6th November 200 at 07:29 PM | |
| jambomb Junior Member |
Okay this is my code so far, but at the moment it just still wont add 1 per minute :S:S::S!!!! Code $getmembers_nerve = mysql_query("SELECT * FROM `members` WHERE `nerveDown` = 'TRUE'") or die(mysql_error()); $members_nerve = mysql_fetch_array($getmembers_nerve); $minute = time() + 60; if($members_nerve[nerveTime] > $minute) { $i = "1"; $nerveUpdate = $members_nerve[nerve] + $i; $insert_nerve = mysql_query("UPDATE `members` SET `nerve` = '$nerveUpdate' WHERE `username` = '$members_nerve[username]';") or die(mysql_error()); } else { $insert_nerve = mysql_query("UPDATE `members` SET `nerveTime` = '$minute' WHERE `username` = '$members_nerve[username]';") or die(mysql_error()); } |
| Posted on Thursday 6th November 200 at 09:39 PM | |
| Matt Newbie |
okay, do you need WHERE `neverDown` = 'TRUE' in your query? you have the query which is restricting your code to only grab data from users with nerveDown = true. pretty much your code is only going to effect the users with nervedown = 'true', but then they will remain being the only ones who get effected by this code, since you don't set it to false inside the if statement. so just try removing that part for now and tell me what happens. |
| Posted on Thursday 6th November 200 at 11:49 PM | |
| jambomb Junior Member |
okay man i tryd that and still doesnt dam work :S this is the code now Code $getmembers_nerve = mysql_query("SELECT * FROM `members`") or die(mysql_error()); $members_nerve = mysql_fetch_array($getmembers_nerve); $minute = time() + 60; if($members_nerve[nerveTime] > $minute) { $i = "1"; $nerveUpdate = $members_nerve[nerve] + $i; $insert_nerve = mysql_query("UPDATE `members` SET `nerve` = '$nerveUpdate' WHERE `username` = '$members_nerve[username]';") or die(mysql_error()); } else { $insert_nerve = mysql_query("UPDATE `members` SET `nerveTime` = '$minute' WHERE `username` = '$members_nerve[username]';") or die(mysql_error()); } |
| Posted on Friday 7th November 2008 at 03:37 PM | |
| Matt Newbie |
PHP Code
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
<?php
okay, you had the queries set in variables, and never ran the variables, this is the code cleaned up, and should work, try it man. |
| Posted on Friday 7th November 2008 at 03:39 PM | |
| Matt Newbie |
sorry for the double post, but this: PHP Code
1
$nerveUpdate = $members_nerve[nerve]++;
needs to be changed to PHP Code
1
$nerveUpdate = $nerve[nerve]++;
|
| Posted on Friday 7th November 2008 at 04:57 PM | |
| jambomb Junior Member |
thanks mate but still doesnt dam work :S:S:S!! fucking soo dam confused mate =[=[=[ this is the code again dude, Code $nerverarray = mysql_query("SELECT * FROM `members`") or die(mysql_error()); $nerve = mysql_fetch_array($nerverarray); $minute = time() + 60; if($nerve[nerveTime] >= $minute) { $nerveUpdate = $nerve[nerve]++; mysql_query("UPDATE `members` SET `nerve` = '$nerveUpdate' WHERE `username` = '$nerve[username]';") or die(mysql_error()); } else { mysql_query("UPDATE `members` SET `nerveTime` = '$minute' WHERE `username` = '$nerve[username]';") or die(mysql_error()); } So not sure wat the hells happening !! |
| Posted on Friday 7th November 2008 at 05:57 PM | |
| Matt Newbie |
okay, so just the queries aren't being executed? you could add me to msn so we can try to fix this a bit quicker. |
| Posted on Friday 7th November 2008 at 06:07 PM | |
| jambomb Junior Member |
my msn highrizeservers@hotmail.com =] thanks alot |