If sending a query. do you NEED quotes or back ticks? ' or ` ?
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.
You don't need either of those for columns. It's best not to use them. Back ticks are MySQL specific.
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.
goootcha.... see i thought i remember reading ticks were only needed if you were doing a query in phpmyadmin.
just wanted to clarify. I wanted to make sure, that way, windows or linux, my db class would work.
seems to be doing fine :)
Ticks mark a user defined entity, I would use them. It prevents errors like this
|All times are GMT. The time now is 12:44 PM.|
Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0