query question

Evulness · 04-21-2008, 04:35 PM

If sending a query. do you NEED quotes or back ticks? ' or ` ?

aka...

Code:

$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'
        );
        ";

mysql_query($query);

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?
if so...
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.