If sending a query. do you NEED quotes or back ticks? ' or ` ?
$query = "
CREATE TABLE IF NOT EXISTS 'users' (
'id' INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
'username' VARCHAR( 255 ) NOT NULL ,
'password' VARCHAR( 255 ) NOT NULL ,
'email' TEXT NOT NULL ,
'ip' VARCHAR( 16 ) NOT NULL ,
'banned' VARCHAR( 5 ) NOT NULL DEFAULT 'n',
'level' INT( 1 ) NOT NULL DEFAULT '1'
I'm trying to use this query via an install script. so that when i'm done on my test server, i can just upload everything, run my install script, and when its installed, delete the installer, so nothing can be changed that way....
my test server is a windows box at home, running WAMP
BUT, i ran into issues with backticks on the linux server i was going to demo my cms on... the admin told me i would need quotes, not back ticks...
he also said that windows treats backticks as quotes.
is that true?
do i even NEED the quotes or backticks, because i've seen many querys without them. or is it personal preference... something to help seperate the different lines?
just curious, because so far, i've kept with the backticks... untill i ran into this issue... using typical phpmyadmin query copy/paste to make sure the query is correct.
"Knowledge is power. Abuse it."~Evulness
My portfolio: www.evularts.com
backticks(`) must mark the field name and quotes (') must mark the data values(you don't need them on the install).
You can omit back ticks whenever your field names are not in conflict with mysql reserved words.
For example if you want to have a field called where you must write: `where` varchar(100) not null......
but if you write
where varchar(100).. it will throw an error.