MySQL prob.
Hej!Hvorfor virker dette ikke?
<?
//TAG
$tag = str_replace("Æ","Æ",$tag);
$tag = str_replace("æ","æ",$tag);
$tag = str_replace("Ø","Ø",$tag);
$tag = str_replace("ø","ø",$tag);
$tag = str_replace("Å","Å",$tag);
$tag = str_replace("å","å",$tag);
$tag = htmlentities($tag);
$tag = str_replace(":D","<img src=img/grin.gif border=0 alt= >",$tag);
$tag = str_replace(":-D","<img src=img/grin.gif border=0 alt= >",$tag);
$tag = str_replace("=D","<img src=img/grin.gif border=0 alt= >",$tag);
$tag = str_replace(";D","<img src=img/grin.gif border=0 alt= >",$tag);
$tag = str_replace("=)","<img src=img/smil.gif border=0 alt= >",$tag);
$tag = str_replace("=]","<img src=img/smil.gif border=0 alt= >",$tag);
$tag = str_replace(":)","<img src=img/smil.gif border=0 alt= >",$tag);
$tag = str_replace(":-)","<img src=img/smil.gif border=0 alt= >",$tag);
$tag = str_replace(":o)","<img src=img/smil.gif border=0 alt= >",$tag);
$tag = str_replace(";)","<img src=img/blink.gif border=0 alt= >",$tag);
$tag = str_replace(";-)","<img src=img/blink.gif border=0 alt= >",$tag);
$tag = str_replace(";o)","<img src=img/blink.gif border=0 alt= >",$tag);
$tag = str_replace("8)","<img src=img/brille.gif border=0 alt= >",$tag);
$tag = str_replace("8-)","<img src=img/brille.gif border=0 alt= >",$tag);
$tag = str_replace(":O","<img src=img/maab.gif border=0 alt= >",$tag);
$tag = str_replace("=o","<img src=img/maab.gif border=0 alt= >",$tag);
$tag = str_replace(":-o","<img src=img/maab.gif border=0 alt= >",$tag);
$tag = str_replace(":0","<img src=img/maab.gif border=0 alt= >",$tag);
$tag = str_replace(":P","<img src=img/tunge.gif border=0 alt= >",$tag);
$tag = str_replace("=P","<img src=img/tunge.gif border=0 alt= >",$tag);
$tag = str_replace(":-P","<img src=img/tunge.gif border=0 alt= >",$tag);
$tag = str_replace(":oP","<img src=img/tunge.gif border=0 alt= >",$tag);
$tag = str_replace(":|","<img src=img/ligeglad.gif border=0 alt= >",$tag);
$tag = str_replace("=|","<img src=img/ligeglad.gif border=0 alt= >",$tag);
$tag = str_replace(":-|","<img src=img/ligeglad.gif border=0 alt= >",$tag);
$tag = str_replace(":o|","<img src=img/ligeglad.gif border=0 alt= >",$tag);
$tag = str_replace(":(","<img src=img/sur.gif border=0 alt= >",$tag);
$tag = str_replace(":-(","<img src=img/sur.gif border=0 alt= >",$tag);
$tag = str_replace(":o(","<img src=img/sur.gif border=0 alt= >",$tag);
$tag = str_replace(":-/","<img src=img/skraa.gif border=0 alt= >",$tag);
$tag = str_replace(":o/","<img src=img/skraa.gif border=0 alt= >",$tag);
$tag = str_replace(":[","<img src=img/vamp.gif border=0 alt= >",$tag);
$tag = str_replace(":-[","<img src=img/vamp.gif border=0 alt= >",$tag);
if (isset($_GET['submit'])) {
$submit = $_GET['submit'];
}
if($submit)
{
$db = mysql_connect("$host", "$db_user", "$db_pass");
mysql_select_db("jaha_ellert",$db) or die(mysql_error());
$sql = "INSERT INTO wall (name, email, url, color, tag, date, remote_addr) VALUES ('$name','$e','$http','$color','$tag','$date','$REMOTE_ADDR')" or die(mysql_error());
$result = mysql_query($sql);
$thanks = "Tak, du!";
};
?>
<form method="post" action="<? $PHP_SELF ?>">
Name: <INPUT type="text" name="name" size="14" maxlength="16">
E-mail: <INPUT type="text" name="email" size="15">
Webside?: <INPUT type="text" name="http" size="18" value="http://">
<SELECT name="color" id="form">
<OPTION selected value="#000000">Choose Color:</OPTION>
<OPTION value="#224466">Dark Blue</OPTION>
<OPTION value="#CC0000">Red</OPTION>
<OPTION value="black">Black</OPTION>
<OPTION value="orange">Orange</OPTION>
<OPTION value="purple">Purple</OPTION>
<OPTION value="silver">Grey</OPTION>
<OPTION value="pink">Pink</OPTION>
</SELECT>
Dit tag: <INPUT type="text" size="41,5" name="tag" id="form" value="Dit tag"><BR>
<INPUT type="hidden" name="submit" value="1">
<DIV align="center"><INPUT type="submit" value=">Tag<"></DIV>
<INPUT type="hidden" name="date" value="<? print date("j/m-Y H:i:s", time()); ?>">
<BR><font color=red><? echo $thanks ?><? echo $errmsg ?></font></form>
