mysql_query($query) - den mou epistrefei ellinika - help!

[chaoz]

Exw ena provlimataki me ta sql queries mou..

Exw ena pinaka me kapoies katigories tis opoies tis grafw sta ellinika.

sto phpmyadmin ta ellinika mou ta diavazei mia xara alla otan paw na ta traviksw apo ena sql query kai na ta kanw print stin selida anti gia ellinika mou vgazei sinexeia erwtimatika (?????) osoi einai oi xaraktires diladi tou string.

 

@mysql_connect(Server, Username,Pass) or die("Could not connect");

@mysql_select_db("mantinades") or die("Could not select");

 

$query = "SELECT * FROM categories;";

$result = mysql_query($query);

 

$x = 0;

$cats = array("ALL");

 

while ($x < mysql_numrows($result)) :

array_push($cats,mysql_result($result, $x, 'categories'));

$x++;

endwhile;

 

mysql_close();

 

Meta kanw ena loop mesa sto array $cats alla ta vgazei me erwtimatika opws sas eipa..

 

Kameia voitheia?

[panosru]

ta idia kai edo.. den ftaiei o kodikas ftaei h MySQL sou. ego molis ekana update apo thn ekdosh 2.32... se 4.1.14(lol?) ta ellhnika apla psofisan (exo kanei kai sxetiko topic gi' ayto to thema den hksera pos ekane allos se allo category allios den tha epibaryna to forum.)

[chaoz]

Telika eprepe na psa3w prwta kai meta na postarw..

Vrika auton ton kwdika se ena allo topic to evala kai epe3an ta ellinika.

Dokimase to kai pes mou..

 

$link = mysql_connect($db_host, $db_user, $db_pass);

mysql_query('set character set greek',$link);

mysql_query("SET NAMES 'greek'",$link);

[panosru]

nai douleyei kanonika alla gia dokimase na deis thn bash sou apo kapoio tool opos to phpMyAdmin h to MySQL Front na deis pos exeis akoma problhma me ta ellhnika. ekei einai pou prepei na epikentrotheis perisotero.

[bandito]

nai douleyei kanonika alla gia dokimase na deis thn bash sou apo kapoio tool opos to phpMyAdmin h to MySQL Front na deis pos exeis akoma problhma me ta ellhnika. ekei einai pou prepei na epikentrotheis perisotero.

 

τι collation εχει η βάση σου;

[panosru]

greek_bin exo dokimasei kai to greek_general_ci

pao na dokimaso kai ta latin giati kati eida pos paizei me ayta kai tha apanthso edo ksana na enymeroso.

[panosru]

mporoume na synexisoume sto allo topic opou briskete sthn kathgoria internet me titlo mysql 1.1.14