MySQL: Syntax fejl. (longtext)
Jeg kan ikke gennemskue hvad jeg gør forkert i min kode. Jeg får følgende fejlmeddelelse: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 ' 'Test Nyhed', Dette er en nyheds test.)' at line 2
Min kode ser således ud:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Upload resultat</title>
</head>
<body>
<?php
$sqlInsert = "";
$sqlDelete = "";
$con = mysql_connect("mydb3.surftown.dk","Mozil_admin","xbox360");
if (!$con) {
die('Could not connect: ' . mysql_error());
}
echo "You are connected to the database <br />";
mysql_select_db("Mozil_uploads", $con);
$date = $_POST['data'];
$header = $_POST['header'];
$text = $_POST['text'];
$sql = "INSERT INTO news (myDate, header, myText)
VALUES (" . $date . ", '" . $header . "', '" . $text . "')";
/*"INSERT INTO news (myDate, header, myText)
VALUES (" . $date . ", '" . $header . "', '" . $text . "')";*/
if (!mysql_query($sql, $con)) {
die('Could not insert into table: ' . mysql_error());
} else {
echo "News element inserted: " . $date . $header . $text;
}
mysql_close($con);
?>
</body>
</html>
og der hvor jeg opretter tabellen ser således ud:
$sql = "CREATE TABLE news (
myDate DATE,
header VARCHAR(50),
myText LONGTEXT
)";
if (!mysql_query($sql,$con)) {
die('Could not create table: ' . mysql_error());
}
Kan nogen se min fejl? (Jeg håber jeg har postet dette spørgsmål under rette kategori. Det var her eller under mySQL.
