Register Problem with '
 

Some users want a ' in their nicks, and for an example the user register A'joe then i get this error..

"Invalid SQL: SELECT COUNT(title) AS starts FROM thread WHERE
postusername='A'joe' AND open!='10'
mysql error: You have an error in your SQL syntax near 'j' AND open!='10'' at
line 1

mysql error number: 1064"

This is when i want to go to his profile ect..

how to fix this ?

See tubedogg's thread for the hack for the solution.

Dont know where that thread is..

Then you should try looking for it, it's not hard to find.