jnull

Thank you ... just perfect!

I have the following select statement: SELECT * FROM `events` WHERE `Category` = "one" OR `Category` = "two" OR `Category` = "three" AND (`StartDate` BETWEEN "2011-06-30" AND "2011-07-05") ORDER BY `Category` It returns data for all date ranges in the categories specified, which is incorrect. If I only have SELECT * FROM `events` WHERE `StartDate` BETWEEN "2011-06-30" AND "2011-07-05" ORDER BY `Category` it returns nothing which is correct response. Can you give me any idea of what's up with the first select statement?

I am trying to create an sql that will go through my entire database that will remove the first few letters form the data in field, for example: The field I want to update must have data that matches these first seven characters, "[b]About: [/b]", thus the data "[b]About: This Title[/b]" when updated should result with "[b]This Title[/b]" as the data. Any help is greatly appreciated!  ::)

Hi ... am on the hunt for a php user authentication solution. Have used phpguarddog but apparently these folks are no longer in business (too bad, was a great solution) and recently used keepsecured (www.octeth.com) but these folks never replied to emails or forum posts for help and so gave up on them. Any recommendations you can provide are most welcome.