NullAhnung
Aktives Mitglied
hallo...
ich brauch mal wieder ein geschultes Auge...meine alten müden Augen finden den Fehler nicht....
CODE
mysql_select_db('gripsle');
$sql="INSERT INTO t_play_PS SELECT ID_PS, question, a1, a2, a3, a4, richtige_A
FROM t_question_language
SET `t_play_PS`.`ID_PS` = '" . $_SESSION['ID_PS'] . "',
`t_play_PS`.`question` = `t_question_language`.`question`,
`t_play_PS`.`a1` = `t_question_language`.`a1`,
`t_play_PS`.`a2` = `t_question_language`.`a2`,
`t_play_PS`.`a3` = `t_question_language`.`a3`,
`t_play_PS`.`a4` = `t_question_language`.`a4`,
`t_play_PS`.`richtige_A` = `t_question_language`.`richtige_A`
WHERE `t_question_language`.`genre_id` = 0
AND `t_question_language`.`language` = '" . $_SESSION['playedLanguage'] . "'
AND ((`t_question_language`.`country` ='" . $_SESSION['playedCountry'] . "') OR (`t_question_language`.`country` = 0))
";
echo mysql_errno() . ": " . mysql_error() . "\n";
$ergebnis2 = mysql_query($sql)OR die("Error: $sql <br>".mysql_error());
da kommt immer eine mySql fehlermeldung...
QUOTE 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 'SET `t_play_PS`.`ID_PS` = '50842469da3a5', `t_play_PS`.`question` = `t_qu' at line 3
hab schon alles versucht ... mit den `usw...
ich brauch mal wieder ein geschultes Auge...meine alten müden Augen finden den Fehler nicht....
CODE
mysql_select_db('gripsle');
$sql="INSERT INTO t_play_PS SELECT ID_PS, question, a1, a2, a3, a4, richtige_A
FROM t_question_language
SET `t_play_PS`.`ID_PS` = '" . $_SESSION['ID_PS'] . "',
`t_play_PS`.`question` = `t_question_language`.`question`,
`t_play_PS`.`a1` = `t_question_language`.`a1`,
`t_play_PS`.`a2` = `t_question_language`.`a2`,
`t_play_PS`.`a3` = `t_question_language`.`a3`,
`t_play_PS`.`a4` = `t_question_language`.`a4`,
`t_play_PS`.`richtige_A` = `t_question_language`.`richtige_A`
WHERE `t_question_language`.`genre_id` = 0
AND `t_question_language`.`language` = '" . $_SESSION['playedLanguage'] . "'
AND ((`t_question_language`.`country` ='" . $_SESSION['playedCountry'] . "') OR (`t_question_language`.`country` = 0))
";
echo mysql_errno() . ": " . mysql_error() . "\n";
$ergebnis2 = mysql_query($sql)OR die("Error: $sql <br>".mysql_error());
da kommt immer eine mySql fehlermeldung...
QUOTE 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 'SET `t_play_PS`.`ID_PS` = '50842469da3a5', `t_play_PS`.`question` = `t_qu' at line 3
hab schon alles versucht ... mit den `usw...