You wouldn't get a (php) parse error with a query alone, that would be an invalid query syntax error.
If it really is a parse error can you post the full php line/code that contains the query?
Could not run query: You have an error in your SQL syntax near '* from tt_Slot ORDER BY SlotName' at line 1
I just said parse error becasue I thought parse errors and syntax errors where basicaly the same thing. I know a php parse error and a mysql syntax error isnt the same thing though so stop telling me.
I think you'll need to use a GROUP BY clause rather than a DISTINCT, i.e along the lines of 'SELECT * FROM tt_Slot GROUP BY SlotName ORDER BY SlotName'
This is a common problem and the above is a guess at the solution as i can't remember the exact syntax. If it still doesn't work i'll go look up the correct format
try my code, it only finds the rows which are unique in their slot name. Meaning, it excludes all rows that have sibling slot names. Which is what I think you asked.. at least that's how I read it.