june_c21 Posted December 14, 2007 Share Posted December 14, 2007 hi, i just can't figure out what's wrong with my code. anyone please help.... thanks CREATE TABLE {$db_prefix}banned ( type tinytext NOT NULL, value tinytext NOT NULL ) TYPE=MyISAM; #1064 - 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 '{$db_prefix}banned ( type tinytext NOT NULL, value tinytext NOT NULL )' at line 1 Quote Link to comment Share on other sites More sharing options...
rajivgonsalves Posted December 14, 2007 Share Posted December 14, 2007 show your code you must be putting it in single quotes instead of double. Quote Link to comment Share on other sites More sharing options...
june_c21 Posted December 14, 2007 Author Share Posted December 14, 2007 huh? i don't understand. can you briefly explain. sorry, i am new with this Quote Link to comment Share on other sites More sharing options...
rajivgonsalves Posted December 14, 2007 Share Posted December 14, 2007 where are you running this piece of sql statement in a php code ? $db_prefix is a variable if your running it in a table creation script remove that Quote Link to comment Share on other sites More sharing options...
june_c21 Posted December 14, 2007 Author Share Posted December 14, 2007 tq. solved Quote Link to comment 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.