Welcome to WebmasterWorld Guest from 220.127.116.11
Any suggestions on speeding up a distinct?
each row in mysql has say one character in it a or b or j or r or 6 etc, im trying to retrieve distinct but its very slow, i have used group by which returns in the correct order but is still slow.
Goal, if the table has an "a" in it i want to echo a link to "a" but not hundreds of them, just one.
If the rows has no "a" it wont echo a link.
Its an A-Z links index i want but i dont want links to pages that have no reuslts,
im poor explaining but hope someone can help