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 Link to comment https://forums.phpfreaks.com/topic/81641-solved-code/ 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. Link to comment https://forums.phpfreaks.com/topic/81641-solved-code/#findComment-414706 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 Link to comment https://forums.phpfreaks.com/topic/81641-solved-code/#findComment-414708 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 Link to comment https://forums.phpfreaks.com/topic/81641-solved-code/#findComment-414710 Share on other sites More sharing options...
june_c21 Posted December 14, 2007 Author Share Posted December 14, 2007 tq. solved Link to comment https://forums.phpfreaks.com/topic/81641-solved-code/#findComment-414712 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.