Hoi Phphulp,
Ik heb voor tot nu toe een best simpel insert script staan om nieuws toe te voegen.
Zo ver ik het kan zien heb ik geen fout gemaakt.. maar helaas krijg ik toch de volgende error:
""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 'longtext, surl, burl, date) VALUES 'Website is online!', 'This is a shorttext bo' at line 1""
Hierbij hoort deze code:
<?php
if(isset($_POST['submit'])) {
if(!empty($_POST['titel']) && !empty($_POST['shorttext']) && !empty($_POST['longtext']) && !empty($_POST['surl']) && !empty($_POST['burl'])) {
$titel = secure($_POST['titel']);
$shorttext = secure($_POST['shorttext']);
$longtext = secure($_POST['longtext']);
$surl = secure($_POST['surl']);
$burl = secure($_POST['burl']);
$date = date('d/m/y H:i:s');
$sql = mysql_query("INSERT INTO news (titel, shorttext, longtext, surl, burl, date) VALUES '".$titel."', '".$shorttext."', '".$longtext."', '".$surl."', '".$burl."', '".$date."'")or die(mysql_error());
if($sql) {
echo('News posted succesful.');
echo('<meta http-equiv="refresh" content="3" />');
} else {
echo'There was an error, please try again.';
echo('<meta http-equiv="refresh" content="3" />');
}
} else {
echo('Not all fields are filled.');
echo('<meta http-equiv="refresh" content="3" />');
}
} else {
echo('
<form method="post" action="#">
<table width="100%" cellpadding="0" cellspacing="2">
<tr>
<td>Titel</td>
<td><input type="text" name="titel" /></td>
</tr>
<tr>
<td>Short news</td>
<td><textarea name="shorttext" rows="4" cols="50" ></textarea></td>
</tr>
<tr>
<td>Long news</td>
<td><textarea name="longtext" rows="4" cols="50" ></textarea></td>
</tr>
<tr>
<td>150x150 image url</td>
<td><input type="text" name="surl" /></td>
</tr>
<tr>
<tr>
<td>*x* image url</td>
<td><input type="text" name="burl" /></td>
</tr>
<tr>
<tr>
<td></td>
<td><input type="submit" name="submit" value="Post" /></td>
</tr>
</table>
</form>');
}
?>
Zou iemand mij kunnen helpen met het achterhalen van de fout..?
