Register | Login | |||||
Main
| Memberlist
| Active users
| ACS
| Commons
| Calendar
| Online users Ranks | FAQ | Color Chart | Photo album | IRC Chat |
| |
0 user currently in Acmlmboard support?. |
Acmlm's Board - I2 Archive - Acmlmboard support? - Damnit.. | | | |
Add to favorites | "RSS" Feed | Next newer thread | Next older thread |
User | Post | ||
TheGreatWhiteDope Koopa Banned Level: 16 Posts: 69/108 EXP: 19462 For next: 794 Since: 01-05-05 Since last post: 8 days Last activity: 4 days |
| ||
I am working on another code and am having problems again. This time I am working on a file that changes settings in the arcade. The only problem is the edit query does absolutely nothing. It doesn't change anything in the users table where it is supposed to. Here is the code, if you can help it will be appreciated. | |||
ExKay Somebody set up us the bomb! Level: 50 Posts: 1047/1114 EXP: 908268 For next: 39049 Since: 03-15-04 From: Hannover, Germany Since last post: 14 hours Last activity: 1 hour |
| ||
Here is a tip: or print mysql_error(); It'll help you to find the error within the query. |
|||
Sokarhacd Ball and Chain Trooper Resistance is Futile You Will Be Assimilated Hab SoSlI' Quch Level: 61 Posts: 1665/1757 EXP: 1799888 For next: 76708 Since: 03-15-04 Since last post: 6 days Last activity: 4 hours |
| ||
I think I see the problem try this mysql_query("UPDATE users SET scale='$scale', sound='$sound', scanline='$scanline', fps='$fps', timeemulation='$timeemulation', showsoundbuffer='$showsoundbuffer' WHERE id=$loguserid"); if you look at existing mysql update queries, you see theres no ` ` around anything, and no .. ' ' around $loguserid. try that...im thinking it should work. (edited by Dcahrakos on 09-26-05 10:23 AM) |
|||
ExKay Somebody set up us the bomb! Level: 50 Posts: 1049/1114 EXP: 908268 For next: 39049 Since: 03-15-04 From: Hannover, Germany Since last post: 14 hours Last activity: 1 hour |
| ||
The quotes aren't the problem, since the queries without them at my board works fine. | |||
Sokarhacd Ball and Chain Trooper Resistance is Futile You Will Be Assimilated Hab SoSlI' Quch Level: 61 Posts: 1668/1757 EXP: 1799888 For next: 76708 Since: 03-15-04 Since last post: 6 days Last activity: 4 hours |
| ||
well, exactly..he had them...its worth a shot atleast, since thats all I can see thats different from all queries, that do actually work. | |||
TheGreatWhiteDope Koopa Banned Level: 16 Posts: 70/108 EXP: 19462 For next: 794 Since: 01-05-05 Since last post: 8 days Last activity: 4 days |
| ||
Araphis: UPDATE `table` SET `field`='value' WHERE `foo`='bar' Araphis: that is PROPER mysql I've tried almost every variation of the query too, first it was copied directly from edituser.php and that didn't even work.... |
|||
DarkSlaya POOOOOOOOOOOORN! Level: 88 Posts: 4136/4249 EXP: 6409254 For next: 241410 Since: 05-16-04 From: Montreal, Quebec, Canada Since last post: 8 hours Last activity: 5 hours |
| ||
Try what Ice Man say, sometimes, it's the data that the query doesn't like. | |||
TheGreatWhiteDope Koopa Banned Level: 16 Posts: 71/108 EXP: 19462 For next: 794 Since: 01-05-05 Since last post: 8 days Last activity: 4 days |
| ||
I did, no error. | |||
ExKeeper Bullet Bill Level: 31 Posts: 493/512 EXP: 180084 For next: 5279 Since: 03-05-05 From: Riiight ^ Since last post: 1 day Last activity: 6 hours |
| ||
change all the stuff in the query that is like $something to ".addslashes($something)." if you do that, it will not glitch if you put a ' in one of the options ($something) | |||
TheGreatWhiteDope Koopa Banned Level: 16 Posts: 72/108 EXP: 19462 For next: 794 Since: 01-05-05 Since last post: 8 days Last activity: 4 days |
| ||
Still doesn't work, it only runs off of numbers, 1 for yes 0 for no. | |||
DarkSlaya POOOOOOOOOOOORN! Level: 88 Posts: 4137/4249 EXP: 6409254 For next: 241410 Since: 05-16-04 From: Montreal, Quebec, Canada Since last post: 8 hours Last activity: 5 hours |
| ||
Dunno if it's related, but always write the full variables ($_POST['scale']) and (if($_POST['action']=='savesettings')) | |||
Elric Chasupa Currently Playing: You Like A Lute. Level: 40 Posts: 609/687 EXP: 440016 For next: 1293 Since: 03-15-04 From: Melniboné Since last post: 6 hours Last activity: 6 hours |
| ||
Similar to what Ice Man said, I always make SQL querys like this:$narf=mysql_query("UPDATE table SET thing=$var") or exit(mysql_error()); If it doesn't exit with an error, then the problem isn't with the SQL query, but with the variables. Have you tried reversing the order, so that it starts with value=0 $checked1=[0] ? I've noticed that sometimes PHP is anal and wants things in a specific order... |
|||
jojodaclowno Blue Octorok Banned Level: 9 Posts: 28/42 EXP: 2849 For next: 313 Since: 07-15-05 From: pa Since last post: 2 days Last activity: 8 hours |
| ||
Quit your complaining GWD your board owns. | |||
Book Keeper ♫♫♫ n00blet ♫♫♫ Level: 21 Posts: 151/160 EXP: 49435 For next: 508 Since: 03-15-04 From: Wired Bookworm eat fresh! Since last post: 20 hours Last activity: 8 hours |
| ||
The only thing that would cause a problem is the ' ' mysql_query("UPDATE users SET scale=$scale,sound=$sound,scanline=$scanline,fps=$fps,timeemulation=$timeemulation,showsoundbuffer=$showsoundbuffer WHERE id=$loguserid"); Should work fine if the php your using is pickie... like mine. Ps. Jojo there are times to say someone's board owns others... but I don't think this was the time. You are ban from Clockworkz board because you were spamming about saying "this board sucks" and other spam like "no one gives a f***", I think you might have said something about GWD's board there as well. Originally posted by Dcahrakos (edited by Bookworm on 09-27-05 05:34 PM) (edited by Bookworm on 09-27-05 05:38 PM) (edited by Bookworm on 09-27-05 05:38 PM) |
|||
TheGreatWhiteDope Koopa Banned Level: 16 Posts: 74/108 EXP: 19462 For next: 794 Since: 01-05-05 Since last post: 8 days Last activity: 4 days |
| ||
Thanks man, that worked, finally. | |||
jojodaclowno Blue Octorok Banned Level: 9 Posts: 30/42 EXP: 2849 For next: 313 Since: 07-15-05 From: pa Since last post: 2 days Last activity: 8 hours |
| ||
Way to go girl, its a girl GWD. | |||
Colleen Administrator Level: 136 Posts: 10779/11302 EXP: 29369328 For next: 727587 Since: 03-15-04 From: LaSalle, Quebec, Canada Since last post: 3 hours Last activity: 1 hour |
| ||
jojo: If you don't have anything meaningful to contribute to this thread, then don't post in it. Simple as that. | |||
TheGreatWhiteDope Koopa Banned Level: 16 Posts: 76/108 EXP: 19462 For next: 794 Since: 01-05-05 Since last post: 8 days Last activity: 4 days |
| ||
One, thats a dude and two, just perma him already. He is trouble and will never change. He has been banned I believe 21 times and is also perma'd at my board.. |
Add to favorites | "RSS" Feed | Next newer thread | Next older thread |
Acmlm's Board - I2 Archive - Acmlmboard support? - Damnit.. | | | |