You have an error in your SQL syntax. Check the manual that corre
MySQL:--
-- Struktur-dump for tabellen `guestbook`
--
CREATE TABLE `guestbook` (
`id` int(5) NOT NULL auto_increment,
`from` varchar(12) NOT NULL default '0',
`username` varchar(50) NOT NULL default '',
`besked` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
tilfoj.php:
<FORM ACTION="tilfojok.php" METHOD="POST">
<INPUT TYPE="text" NAME="from" VALUE="Fra"><br>
<INPUT TYPE="text" NAME="bruger" VALUE="Til" class="text"><input type="text" name="besked" class="text"><br>
<INPUT TYPE="submit" VALUE="Send">
</FORM>
tilfojok.php:
<?
include("../sql.php");
mysql_query("INSERT INTO guestbook (from, username, besked) VALUES('$from','$bruger','$besked')") or die(mysql_error());
print "Din besked blev sendt!";
?>
Jeg har lavet et community med gæstebøger tildelt til hver bruger.. Men når man sender en besked siger den:
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 'from, username, besked) VALUES('Fra','Til','Besked')' at line 1
