SA-MP Forums Archive
Mysql Error help!! - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Mysql Error help!! (/showthread.php?tid=223965)


Mysql Error help!! - showarn - 10.02.2011

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'

Re: Mysql Error help!! - viKKmaN - 10.02.2011

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

Re: Mysql Error help!! - showarn - 10.02.2011

MySQL sa: Dokumentation
INT(DIGITS) 1?

Re: Mysql Error help!! - viKKmaN - 10.02.2011

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.