Collation problem

[Crazy Heart]

Hi everyone!
I have a problem with my site! it has Greek fonts, and although I've set the Collation from phpmyadmin (Operations) to Greek_general_ci, I keep getting this "?????" instead of greek fonts!
MySQL version is 4.1.21 and php version is 4.4.4

and another problem: I have this code
$dbquery = "SELECT classId, classname, moviename, equipment, classes.groupId, groupname FROM classes"
."INNER JOIN groups ON classes.groupId = groups.groupId where classId=".$cid." order by classId asc";
$res = mysql_query($dbquery, $dbid) or die(mysql_error());

and I get this You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by 'classId' asc' at line 1 :confused: :confused:

any ideas would be much appreciated!

thanks!

[chazzy]

for your greek problem, i believe that this is a problem w/ the basic mysql drivers used when you use the "mysql" functions in PHP, rather than the MySQLi class.

as for the query syntax, i only see 2 things. 1 is that you might want to add a space inside the query between "classes" and "INNER JOIN", it could be thinking you wrote "classesINNER JOIN", but not sure. what is the type of classId?

[Crazy Heart]

classId type is INT. and there is a space when inner join starts in a different row so that's not it...

thanks anyway!

[chazzy]

could you give the full table structure of both tables?