Welcome Guest, Not a member yet? Register   Sign In
Or_where Help
#3

[eluser]KingSkippus[/eluser]
Just a short best practice note. Use backticks in MySQL for database, table, or column names, but use single quotation marks for string literals. Your original query should have been:

Code:
SELECT *
FROM `users`
WHERE `city` = 'dallas' AND (`type` = 'a' OR `role` = 'lead')


Messages In This Thread
Or_where Help - by El Forum - 07-21-2010, 08:00 AM
Or_where Help - by El Forum - 07-21-2010, 08:16 AM
Or_where Help - by El Forum - 07-21-2010, 12:29 PM
Or_where Help - by El Forum - 07-21-2010, 01:07 PM
Or_where Help - by El Forum - 07-21-2010, 09:07 PM



Theme © iAndrew 2016 - Forum software by © MyBB