Update bazy danych mysql, problem z dodaniem nowych tabel Opcje

[saperek25]

jak w temacie oto kod

[PHP] pobierz, plaintext 
<?php
	$link = mysql_connect("localhost", "root", "tatiana13")
		or die("Sprawdź połączenie z serwerem.");
	mysql_select_db("moviesite")
		or die(mysql_error());
 
	//modyfikacja tabeli "movie" w celu dodania pól czasu trwania, kosztu i zysków
	$add = "ALTER TABLE movie AND COLUMN ( " .
		"movie_running_time int NULL, " .
		"movie_cost int NULL, " .
		"movie_takings int NULL)";
	$results = mysql_query($add)
		or die(mysql_error());
 
	//wstawienie nowych danych do tabeli "movie" dla każdego filmu
	$update = "UPDATE movie SET " .
		"movie_running+time=102, " .
		"movie_cost=10, ".
		"movie_takings=15 ".
		"WHERE movie_id = 1";
	$results = mysql_query($update)
		or die(mysql_error());
 
	$update = "UPDATE movie SET " .
		"movie_running_time=90, " .
		"movie_cost=3, " .
		"movie_takings=90 ".
		"WHERE movie_id = 2";
	$results = mysql_query($update)
		or die(mysql_error());
 
	$update = "UPDATE movie SET " .
		"movie_running_time=134, " .
		"movie_cost=15, " .
		"movie_takings=10 " .
		"WHERE movie_id = 3";
	$results = mysql_query($update)
		or die(mysql_error());
?>
[PHP] pobierz, plaintext 

błąd 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 'AND COLUMN ( movie_running_time int NULL, movie_cost int NULL, movie_takings int' at line 1

[czachor]

Kod

$add = "ALTER TABLE movie AND COLUMN ( " .         // zmień AND na ADD

Ten post edytował czachor 12.11.2010, 19:01:33