Hi,
I have made a guestbook, it's some problem with posting the information into the database ! I don't get errors, but as said it wont post anything into the db ! Maybe I have done something wrong in phpmyadmin?
asked on usenet, they said something about register_globals, i'm a little bit newbie here :rolleyes:
Thanks for all the help I get !
* gbook.php *
<?
if($submit)
{
mysql_connect("localhost","steinar","xxx");
mysql_select_db("myplayground");
$result=MYSQL_QUERY("INSERT INTO gbook (id,name,mail,web,message)".
"VALUES ('NULL','$name','$mail','$web','$message')");
print "<p>Guestbook signed";
}
else
{
?>
<form method="post" action="gbook.php">
name<br>
<input name="name" type="text" size="25">
<br>
e-mail<br>
<input name="mail" type="text" size="25">
<br>
website<br>
<input name="web" type="text" value="http://" size="25">
<br>
message <br>
<textarea name="message" cols="25"></textarea>
<br>
<input type="image" src="../../img/sign.gif" name="submit" value="submit"
width="48" height="23" alt="sign">
</form><br>
<?
}
?>
<?
mysql_connect("localhost","steinar","xxx");
mysql_select_db("myplayground");
$result = mysql_query("select * from gbook");
while($r=mysql_fetch_array($result))
{
$name=$r["name"];
$mail=$r["mail"];
$mail = "<a href=\"mailto:" . $r["mail"] . "\">" . $r["mail"] . "</a>";
$web=$r["web"];
$web = "<a href=\"" . $r["web"] . "\">" . $r["web"] . "</a>";
$message=$r["message"];
echo "$name<br> $message<br> $web<br> $mail<br>";
}
?>