Illegal Characters

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

User avatar
Ollie Saunders
DevNet Master
Posts: 3179
Joined: Tue May 24, 2005 6:01 pm
Location: UK

Post by Ollie Saunders »

boo_lolly wrote:you've got back-ticks (`) around vehicles-temp, not single quotes (').
That is an encouraged practice in SQL
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

from what I've been told and see, backticks are a construct specific to MySQL.. so unless you know for absolute certainty that you aren't going to use another database management system, backticks are fine. It's better to use field and table names that aren't keywords more. :)
User avatar
Ollie Saunders
DevNet Master
Posts: 3179
Joined: Tue May 24, 2005 6:01 pm
Location: UK

Post by Ollie Saunders »

from what I've been told and see, backticks are a construct specific to MySQL..
Really?! Wow. But they are such a good idea in a keyword based language though.
Last edited by Ollie Saunders on Wed Jan 10, 2007 3:12 pm, edited 1 time in total.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

I haven't found another RDBMS that uses backticks. I use them in my procedures, but not so much in direct calls (though those are going down dramatically now).
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post by volka »

User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

Dude, is there anything that you don't know (or can't find)? You got my vote for most helpful this year bro.
User avatar
boo_lolly
Forum Contributor
Posts: 154
Joined: Tue Nov 14, 2006 5:04 pm

Post by boo_lolly »

ole wrote:
boo_lolly wrote:you've got back-ticks (`) around vehicles-temp, not single quotes (').
That is an encouraged practice in SQL
ole is pretty helpful too =)
User avatar
Ollie Saunders
DevNet Master
Posts: 3179
Joined: Tue May 24, 2005 6:01 pm
Location: UK

Post by Ollie Saunders »

boo_lolly wrote:
ole wrote:
boo_lolly wrote:you've got back-ticks (`) around vehicles-temp, not single quotes (').
That is an encouraged practice in SQL
ole is pretty helpful too =)
Eh up! This year is going to be competitive :D
Post Reply