[MySQL][PHP] Update bazy danych Opcje

[Lethys]

Mam problem, moja baza wyglada tak:

Tabela : dzienne

|all|1|2|3|4|5|6|7|8|


Komenda w php :

[PHP] pobierz, plaintext 
mysql_query("update dzienne set (all, 1, 2, 3, 4, 5, 6, 7, 8) values('0','0','0','0','0','0','0','0','0')") or die(mysql_error());
 
[PHP] pobierz, plaintext 

Wywala mi blad :

Something is wrong in your syntax obok '(all, 1, 2, 3, 4, 5, 6, 7, 8) values('0','0','0','0','0','0','0'' w linii 1

Co jest zle ?

Ten post edytował Lethys 25.11.2010, 14:45:49

[Lethys]

Teraz mam

[PHP] pobierz, plaintext 
mysql_query("update dzienne set all='0',1='0',2='0',3='0',4='0',5='0',6='0',7='0',8='0'") or die(mysql_error());
[PHP] pobierz, plaintext 

i wywala :

Something is wrong in your syntax obok 'all='0',1='0',2='0',3='0',4='0',5='0',6='0',7='0',8='0'' w linii 1