doesnt work for me. i can find the syntax in manual, on phpbuilder forums but it just wont work. what did i do wrong?
i can however use SELECT DISTINCT(id_session) and then read affected_rows() but i prefer COUNT if possible.
MySql version: 3.22.32
SELECT COUNT(DISTINCT id_session) WHERE (access_time > ....)
MySQL Error: 1064 (You have an error in your SQL syntax near 'DISTINCT id_session
i can however use SELECT DISTINCT(id_session) and then read affected_rows() but i prefer COUNT if possible.
MySql version: 3.22.32
SELECT COUNT(DISTINCT id_session) WHERE (access_time > ....)
MySQL Error: 1064 (You have an error in your SQL syntax near 'DISTINCT id_session