[Resolved] Sql Error

[fean0r]

$sql = "UPDATE ladders SET
name='$name',
game='$game',
type='type',
1='$1',
2='$2',
3='$3',
4='$4',
5='$5',
6='$6',
7='$7',
8='$8',
9='$9',
10='$10',
11='$11',
12='$12',
13='$13',
14='$14',
15='$15',
16='$16',
17='$17',
18='$18',
19='$19',
20='$20',
21='$21',
22='$22',
23='$23',
24='$24',
25='$25',
26='$26',
27='$27',
28='$28',
29='$29',
30='$30',
31='$31',
32='$32',
33='$33',
34='$34',
35='$35',
36='$36',
37='$37',
38='$38',
39='$39',
40='$40',
41='$41',
42='$42',
43='$43',
44='$44',
45='$45',
46='$46',
47='$47',
48='$48',
49='$49',
50='$50',
51='$51',
52='$52'
WHERE ID='$table'";

I'm getting the following error message with this code, any ideas whats wrong?

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '1='$1', 2='$2', 3='$3', 4='$4', 5='$5', 6='$6', 7='$7', 8='$8',

Thanks

[tguill]

The only thing I see is :

type='type', 

might try

type='$type',

[fean0r]

nah I fixed that but either way it wouldn't create that error....

[fean0r]

I found the problem

It doesn't like fields being called numbers ie. 1

so i renamed them all to w1, w2 etc

$sql = "UPDATE ladders SET name='$name', game='$game', type='$type',
w1='$r1', w2='$r2', w3='$r3', w4='$r4', w5='$r5', w6='$r6', w7='$r7', w8='$r8', w9='$r9', w10='$r10',
w11='$r11', w12='$r12', w13='$r13', w14='$r14', w15='$r15', w16='$r16', w17='$r17', w18='$r18', w19='$r19', w20='$r20',
w21='$r21', w22='$r22', w23='$r23', w24='$r24', w25='$r25', w26='$r26', w27='$r27', w28='$r28', w29='$r29', w30='$r30',
w31='$r31', w32='$r32', w33='$r33', w34='$r34', w35='$r35', w36='$r36', w37='$r37', w38='$r38', w39='$r39', w40='$r40',
w41='$r41', w42='$r42', w43='$r43', w44='$r44', w45='$r45', w46='$r46', w47='$r47', w48='$r48', w49='$r49', w50='$r50',
w51='$r51', w52='$r52' WHERE ID='$table'";