Mensen,
ik heb me er al verrot achter gezocht, en ik kan de fout maar niet gevonden krijgen... Hopelijk zien jullie ze wel!
boven head sectie:
<?php
include("connection.php");
if ($HTTP_POST_VARS["Toevoegen"] == "Toevoegen") {
mysql_query("INSERT INTO `news` (`tekst`, `naam`, `datum`) VALUES ('".$HTTP_POST_VARS['tekst']."', '".$HTTP_POST_VARS['naam']."', NOW())");
}
if ($HTTP_GET_VARS['id'] != "" ){
mysql_query("DELETE FROM news WHERE news_id = " . $HTTP_GET_VARS['id']);
}
$query = mysql_query("SELECT * FROM news ORDER BY datum DESC");
for ($i = 1 ; $i <= mysql_num_rows($query) ; $i++){
$t = mysql_fetch_array($query);
?>
in body sectie:
<?php
include("connection.php");
$query = mysql_query("SELECT * FROM news ORDER BY datum DESC");
for ($i = 1 ; $i <= mysql_num_rows($query) ; $i++){
$t = mysql_fetch_array($query);
?></p>
<table width="100%" border="0" cellspacing="5" cellpadding="5">
<tr>
<td width="11%" height="30" valign="top"><strong>Naam</strong></td>
<td width="89%" height="30" valign="top"><span class="oranje"><?php echo nl2br($t['naam']); ?></span></td>
</tr>
<tr>
<td height="30" valign="top"><strong>Datum</strong></td>
<td height="30" valign="top"><span class="oranje"><?php echo date("j - n - Y", strtotime($t['datum'])); ?></span></td>
</tr>
<tr>
<td height="30" valign="top"><strong>Bericht</strong></td>
<td height="30" valign="top"><?php echo nl2br($t['tekst']); ?></td>
</tr>
</table>
<p><br />
<?php } ?>
</p>
<form name="form1" method="post" action="">
<label>
<div align="center">
<table width="100%" border="0" cellspacing="5" cellpadding="5">
<tr>
<td width="11%" height="30" valign="top"><strong>Naam</strong></td>
<td width="89%" height="30" valign="top"><label></label>
<label>
<input name="naam" id="naam" size="25" />
</label></td>
</tr>
<tr>
<td height="30" valign="top"><strong>Bericht</strong></td>
<td height="30" valign="top"><textarea name="tekst" cols="50" rows="10" id="tekst"></textarea></td>
</tr>
<tr>
<td height="30" valign="top"> </td>
<td height="30" valign="top"><input type="submit" name="Toevoegen" id="Toevoegen" value="Toevoegen" /></td>
</tr>
</table>
<p> </p>
<p></label>
</p>
<p align="center"> </p>
</div>
</form>
718 views
knop om dit te doen.