You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''shoutbox28' VALUES('',1,'f',unix_timestamp())' at line 1
this is for a shoutbox with a variable to point to group specific table
Relevant portion of code:
if($_POST['message'] != "")
{
$_POST['message']=mysql_real_escape_string(trim(strip_tags($_POST['message'])));
$message=($_POST['message']);
//smileys
$key = array(":)", ":(", ";)", ":D", ":innocent", ":hug", ":/", ":x", ":blush", ":P", ":*", ":broken", ":o", ":mad", ":sly", "B-)", ":-S", "=))", ":-$", ":thumbs", ":devil", ":angel", ":nerd", ":whatever", ":sleep", ":roll", ":loser", ":clown", ":hmmm", ":drool");
$images = array("<img src=smileys/1.gif>", "<img src=smileys/2.gif>", "<img src=smileys/3.gif>", "<img src=smileys/4.gif>", "<img src=smileys/5.gif>", "<img src=smileys/6.gif>", "<img src=smileys/7.gif>", "<img src=smileys/8.gif>", "<img src=smileys/9.gif>", "<img src=smileys/10.gif>", "<img src=smileys/11.gif>", "<img src=smileys/12.gif>", "<img src=smileys/13.gif>", "<img src=smileys/14.gif>", "<img src=smileys/15.gif>", "<img src=smileys/16.gif>", "<img src=smileys/17.gif>", "<img src=smileys/18.gif>", "<img src=smileys/19.gif>", "<img src=smileys/20.gif>", "<img src=smileys/21.gif>", "<img src=smileys/22.gif>", "<img src=smileys/23.gif>", "<img src=smileys/24.gif>", "<img src=smileys/25.gif>", "<img src=smileys/26.gif>", "<img src=smileys/27.gif>", "<img src=smileys/28.gif>", "<img src=smileys/29.gif>", "<img src=smileys/30.gif>");
$message = str_replace($key, $images, $message);
$shout="shoutbox".$ir['gang'];
mysql_query("INSERT INTO shoutbox VALUES('',{$ir['userid']},'$message',unix_timestamp())",$c) or die (mysql_error());
print "<form action='". $_SERVER['PHP_SELF'] ."' method='post' name='form' form='form1' onSubmit=\"return disableForm(this);\"><b>Message: </b><input type='text' name='message' maxlength='255' size='31'><br><input type='Submit' value='Post Message'><input type='reset' value='Reset Message'></form><br/><br/>";
}
else
{
//Submit button JS Start
print <<<EOF
<SCRIPT LANGUAGE="JavaScript">
<!-- Begin
function disableForm(theform) {
if (document.all || document.getElementById) {
for (i = 0; i < theform.length; i++) {
var tempobj = theform.elements[i];
if (tempobj.type.toLowerCase() == "submit" || tempobj.type.toLowerCase() == "reset")
tempobj.disabled = true;
}
return true;
}
else {
return false;
}
}
// End -->
</script>
