Hamlets666 Posted January 5, 2007 Share Posted January 5, 2007 [code]$onlinesave="INSERT INTO store(opis, owner, moneybuy, wepa1, wepa2, wepa3, wepa4, wepa5, wepa1m, wepa2m, wepa3m, wepa4m, wepa5m, cara1, cara2, cara3, cara4, cara5, cara1m, cara2m, cara3m, cara4m, cara5m)values('$opis', '$owner', '$moneybuy, '$wepa1', '$wepa2', '$wepa3', '$wepa4', '$wepa5', '$wepa1m', '$wepa2m', '$wepa3m', '$wepa4m', '$wepa5m', '$cara1', '$cara2', '$cara3', '$cara4', '$cara5', '$cara1m', '$cara2m', '$cara3m', '$cara4m', '$cara5m')";mysql_query($onlinesave) or die(mysql_error());[/code]and result :[b]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 'LOL', '666', '666', '666', '666', '666', '666', '666', '666', '666', '666', '666' at line 1[/b]DUMP:[code]CREATE TABLE `store` (`id` BIGINT NOT NULL AUTO_INCREMENT ,`opis` TEXT NOT NULL ,`owner` TEXT NOT NULL ,`moneybuy` BIGINT NOT NULL ,`wepa1` TEXT NOT NULL ,`wepa2` TEXT NOT NULL ,`wepa3` TEXT NOT NULL ,`wepa4` TEXT NOT NULL ,`wepa5` TEXT NOT NULL ,`wepa1m` BIGINT NOT NULL ,`wepa2m` BIGINT NOT NULL ,`wepa3m` BIGINT NOT NULL ,`wepa4m` BIGINT NOT NULL ,`wepa5m` BIGINT NOT NULL ,`cara1` TEXT NOT NULL ,`cara2` TEXT NOT NULL ,`cara3` TEXT NOT NULL ,`cara4` TEXT NOT NULL ,`cara5` TEXT NOT NULL ,`cara1m` BIGINT NOT NULL ,`cara2m` BIGINT NOT NULL ,`cara3m` BIGINT NOT NULL ,`cara4m` BIGINT NOT NULL ,`cara5m` BIGINT NOT NULL ,PRIMARY KEY ( `id` ) );[/code]Varuables:[quote]opis - LOLowner - dyzastermoneybuy - 12wepa1 - LOLwepa2 - 666wepa3 - 666wepa4 - 666wepa5 - 666wepa1m - 666wepa2m - 666wepa3m - 666wepa4m - 666wepa5m - 666cara1 - 666cara2 - 666cara3 - 666cara4 - 666cara5 - 666cara1m - 666cara2m - 666cara3m - 666cara4m - 666cara5m - 666[/quote] Link to comment https://forums.phpfreaks.com/topic/32968-mysql-error/ Share on other sites More sharing options...
complex05 Posted January 5, 2007 Share Posted January 5, 2007 which variable is LOL? Link to comment https://forums.phpfreaks.com/topic/32968-mysql-error/#findComment-153539 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.