link naar nieuwssysteem tutorial:
http://www.phphulp.nl/php/tutorials/3/52/
ik wil graag dat mensen maar 1x kunnen reageren op nieuws berichten, hoe doe ik dat?
ik had zo iets verzonnen, maar dat werkt niet :(
<?
$sql = "SELECT name,class FROM guildmembers WHERE id='".$_SESSION['user_id']."'";
$res = mysql_query($sql);
$row = mysql_fetch_array($res);
$checksql = "SELECT name FROM subscribers WHERE tid='".$HTTP_GET_VARS[id]."'";
$checkres = mysql_query($checksql);
$checkrow = mysql_fetch_array($checkres);
if($_checkrow['name']!=$_row['name']) {
echo "you have allready subscribed to this event!";
}
else
$query ="INSERT INTO subscribers (date,name,class,tid) VALUES ('".date('Y-m-d H:i:s')."','".$row['name']."','".$row['class']."','".$HTTP_GET_VARS[id]."')";
mysql_query($query) or die (mysql_error());
header("location:event.php?id=".$HTTP_GET_VARS[id]."");
?>