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
Ollie Saunders
DevNet Master
Posts: 3179 Joined: Tue May 24, 2005 6:01 pm
Location: UK
Post
by Ollie Saunders » Wed Jan 10, 2007 1:26 pm
boo_lolly wrote: you've got back-ticks (`) around vehicles-temp, not single quotes (').
That is an encouraged practice in SQL
feyd
Neighborhood Spidermoddy
Posts: 31559 Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA
Post
by feyd » Wed Jan 10, 2007 1:38 pm
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.
Ollie Saunders
DevNet Master
Posts: 3179 Joined: Tue May 24, 2005 6:01 pm
Location: UK
Post
by Ollie Saunders » Wed Jan 10, 2007 1:39 pm
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.
RobertGonzalez
Site Administrator
Posts: 14293 Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA
Post
by RobertGonzalez » Wed Jan 10, 2007 3:04 pm
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).
volka
DevNet Evangelist
Posts: 8391 Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger
Post
by volka » Wed Jan 10, 2007 3:23 pm
RobertGonzalez
Site Administrator
Posts: 14293 Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA
Post
by RobertGonzalez » Wed Jan 10, 2007 10:22 pm
Dude, is there anything that you don't know (or can't find)? You got my vote for most helpful this year bro.
boo_lolly
Forum Contributor
Posts: 154 Joined: Tue Nov 14, 2006 5:04 pm
Post
by boo_lolly » Thu Jan 11, 2007 9:17 am
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 =)
Ollie Saunders
DevNet Master
Posts: 3179 Joined: Tue May 24, 2005 6:01 pm
Location: UK
Post
by Ollie Saunders » Thu Jan 11, 2007 9:51 am
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