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] 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? Quote Link to comment https://forums.phpfreaks.com/topic/32968-mysql-error/#findComment-153539 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.