The problem is not with your query then it sounds more like a problem with your output code. You should check (if possible) using phpMyAdmin or something of the sort, what the data looks like in the Database. If the titles are split up like "Signature of the Month" "Member of the Month" then the problem lies with your output code and not the query.
Also, on a side note, when you use the AS keyword it allows you to use a different name for reference to that table so you can say
[sql]FROM ... candvoting_nominee AS cdv_nom[/sql]
Then you just use cdv_nom in the rest of your query, just to make it easier for you and make the query a bit shorter (visually)
|