Hi Mac
In phpMyAdmin I select the SQL tab and run the below SQL
Language: SQL
CREATE TABLE IF NOT EXISTS ';users';(
';user_id'; INT(11) NOT NULL AUTO_INCREMENT,
';first_name'; VARCHAR(20) DEFAULT NULL,
';last_name'; VARCHAR(50) DEFAULT NULL,
';display_name'; VARCHAR(50) DEFAULT NULL,
PRIMARY KEY(';user_id';)
)ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7;
then I get the following error:
#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 ''users'( 'user_id' int(11) NOT NULL AUTO_INCREMENT, 'first_name' varchar(20) D' at line 1
I get the same error when running CREATE TABLE IF NOT EXISTS 'user_friends'()
Am I doing this right? Are we suppose to run this SQL in phpMyAdmin to create the tables and insert the data
Please assist
***Lets go back to my place and I will show you my source code***