Hallo,
ich möchte gerne Inhalte von einer Tabelle in die andere speichern. Es kommt aber immer eine Fehlermeldung, die mit dem Syntax zutun hat.
Code:
PHP
<?php
require_once 'config2.php';
$link = mysql_connect($server, $user, $password);
mysql_select_db($dbname);
$query = '
SELECT
`link`,
`infoid`,
`name`,
`size`,
`lastupdate`,
`tracker`
FROM
`cm_dl_links`
ORDER BY
`id`
';
$result = mysql_query($query, $link);
while( $row = mysql_fetch_assoc($result) ) {
$query = '
UPDATE
`cm_dl_info`
SET
`link` = "'.mysql_real_escape_string($row['link']).'",
`dlname` = "'.mysql_real_escape_string($row['name']).'",
`size` = "'.mysql_real_escape_string($row['size']).'",
`lastupdate` = "'.mysql_real_escape_string($row['lastupdate']).'",
`tracker` = "'.mysql_real_escape_string($row['tracker']).'"
WHERE
`id` = "'.$row['infoid'].'
';
mysql_query($query, $link)
or die(mysql_error());
}
?>Fehlermeldung:
PHP
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' at line 10