Hi can someone help me ???
i am currently trying to make a shoutbox for my website,
This is the code i have got so far.
The error i am getting is shown below the code.
<?php
include("config.php");
if($POST['submit']) {
if(!$POST['author']) {
echo 'Error ! : No name entered';
die;
}
if(!$POST['email']) {
echo 'Error ! : No email entered';
die;
}
if(!$POST['message']) {
echo 'Error ! : No message entered';
die;
}
$message = strip_tags($POST['message'], '');
$email = strip_tags($POST['email'], '');
$author = strip_tags($_POST['author'], '');
$message_length = strlen($message);
$author_length = strlen($author);
if($message_length > 150) {
echo "Error ! : Your message was too long, messages must be less than 150 chars";
die;
}
if($author_length > 150) {
echo "Error ! : Your name was too long, names must be less than 150 chars";
die;
}
mysql_connect($db_host,$db_user,$db_pass) or die(mysql_error());
mysql_select_db($db_name) or die(mysql_error());
$date = date("h:i A dS M");
$query = "INSERT INTO site_shoutbox (message, author, email, date)
VALUES ('$message','$author','$email','$date')";
mysql_query($query);
mysql_close();
echo "Thanks for your post<BR>";
echo "<A HREF=\"shoutbox.php\">View the shoutbox</A>";
} else {
mysql_connect($db_host,$db_user,$db_pass) or die(mysql_error());
mysql_select_db($db_name) or die(mysql_error());
$query = "SELECT * FROM shoutbox";
$result = mysql_query($query);
echo "<TABLE>";
while($r=mysql_fetch_array($result))
{
echo "<TR>
<TD><font size='1'>
Posted $r[date] by <A HREF=\"mailto:$r[email]\">
$r[author]</A></font></TD>
</TR>
<TR>
<TD><font size='1'>$r[message]</font></TD>
</TR>
<TR>
<TD><HR></TD>
</TR>";
}
echo "</TABLE>";
?>
<FORM METHOD=POST ACTION="shoutbox.php">
<TABLE>
<TR>
<TD>Name :</TD>
<TD><INPUT TYPE="text" NAME="author"></TD>
</TR>
<TR>
<TD>Email :</TD>
<TD><INPUT TYPE="text" NAME="email"></TD>
</TR>
<TR>
<TD>Message :</TD>
<TD><INPUT TYPE="text" NAME="message"></TD>
</TR>
<TR>
<TD> </TD>
<TD><INPUT TYPE="submit" name="submit" value="post"></TD>
</TR>
</TABLE>
</FORM>
<?php
}
?>
This is the error my server keeps giving to me...
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/devlyn00/public_html/shoutbox.php on line 44
If you can offer ANY help please do, thank you, i can also be contacted via email to gavin@hansonhq.com
