Hej, mam problem. Mianowicie wykonanie skryptu powoduje dodanie dwóch jednakowych rekordów do bazy danych... Nie wiem, jak problem ten rozwiązać:
$connect = mysql_connect("$DatabaseHost","$DatabaseUserName","$DatabasePassword")
or die(Go_Error(mysql_errno()));
$db = mysql_select_db($DatabaseName, $connect)
or die(Go_Error(mysql_errno()));
$haz = mysql_query("SELECT hash FROM koments", $connect);
if ('$haz' == '$hash')
{
echo 'Wpis dodany!';
}
elseif ($message and $fp)
{
$result = mysql_query("INSERT INTO `koments`(`fp`, `message`, `hash`) VALUES('$fp', '$message', '$hash')", $connect)
or die(Go_Error(mysql_errno()));
}
$zapytanko = mysql_query("SELECT fp, message FROM koments", $connect);
while ($r = mysql_fetch_array($zapytanko))
{
echo $r['fp'] . ' napisał ' . $r['message'] .
'<br />';
}
?>
<FORM method="post">
<input type="hidden" id="hash" name="hash" value="<?=generateHash();?>">
<?php
function generateHash()
{
}
?>
<b>Your name:</b><BR><INPUT name="fp" type="text" size="55"><BR>
<b>Your comment:</b><BR><TEXTAREA name="message" rows=10 cols=55 wrap=virtual>
</TEXTAREA><BR>
<INPUT name="submit" type="submit" value="Post your comments">
</FORM>
</body>
</html>