Mysql Error help!!
#1

Hello i get error on my website or i added a FS wich uses mysql and i created a database but i get bugg


Код:
MySQL sa: Dokumentation
#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 'mysql_query("CREATE TABLE IF NOT EXISTS `Vehicles` \
        (`CarID` INT NOT NULL,`M' at line 1
and when i go to my website i get Unknown column 'CarID' in 'field list'
Reply
#2

Try
pawn Код:
INT(DIGITS) //where digits is the max number of digits the column value can have
And also post line 1
Reply
#3

MySQL sa: Dokumentation
INT(DIGITS) 1?
Reply
#4

Yes, if you want that column to have values with maximum 8 digits you put INT(8 ), if you want 3 digits you put INT(3).
And post the entire query code so i can debug it.
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)