[php] problem z updatem! pomożcie! PLz!

0

Mam taki kod

	if ($edit == 'yes')
	{
		mysql_query("UPDATE favourite SET color = '$color', flower = '$flower', fruit = '$fruit', vegetable = '$vegetable', actor = '$actor', actress = '$actress', directory = '$directory', movie = '$movie', sportman = '$sportman', sport = '$sport', singerm = '$singerm', singerw = '$singerw', group = '$group', song = '$song', writer = '$writer', book = '$book', food = '$food', school = '$school', magazine = '$magazine' WHERE blogname = '$login'");
		echo "Strona 'Moje ulubione' została zaukualizowana!";
	}
	

tekst z echo mi wyświetla ale nie updateuje :/

0

if ($edit == 'yes')
{
if(mysql_query("UPDATE favourite SET color = '$color', flower = '$flower', fruit = '$fruit', vegetable = '$vegetable', actor = '$actor', actress = '$actress', directory = '$directory', movie = '$movie', sportman = '$sportman', sport = '$sport', singerm = '$singerm', singerw = '$singerw', group = '$group', song = '$song', writer = '$writer', book = '$book', food = '$food', school = '$school', magazine = '$magazine' WHERE blogname = '$login'"))
echo "Strona 'Moje ulubione' została zaukualizowana!";
else echo ("Coś jest skopane!");

}

group to słowo zarezerwowane sql'a, nie moze być takiego pola !

Miałem ten sam problem gdy w bazie danych pole zawierajace opis czegos tam nazwałem "desc" (od description).

0

Moze jest błąd w zapytaniu który trzeba poprawić:

	if ($edit == 'yes')
	{
$var = "UPDATE favourite SET color = '$color', flower = '$flower', fruit = '$fruit', vegetable = '$vegetable', actor = '$actor', actress = '$actress', directory = '$directory', movie = '$movie', sportman = '$sportman', sport = '$sport', singerm = '$singerm', singerw = '$singerw', group = '$group', song = '$song', writer = '$writer', book = '$book', food = '$food', school = '$school', magazine = '$magazine' WHERE blogname = '$login'";

echo "<BR>".$var."<BR>";
if (!mysql_query($var))
   echo "<BR>".mysql_errno().": ".mysql_error()."<BR>";
else
	echo "Strona 'Moje ulubione' została zaukualizowana!";
	}
	

1 użytkowników online, w tym zalogowanych: 0, gości: 1