Problima SQL

[mixalis8]

$query = 'SELECT idIpotitlou, OnomaTainias, Uploader, ImerominiaUpload, Downloads, EkdosiTainias, Glossa, idTainias FROM `Subtitles` WHERE `OnomaTainias` LIKE CONVERT(_utf8 \'o%\' USING greek) COLLATE greek_general_ci ORDER BY `ImerominiaUpload` DESC';

 

to erotima afto leitourgei kanonika... apla thelo na to kano anti gia na einai panta "o" na allazi simfona me mia metabliti...

 

to gramma afto to exei i metabliti $katigoria

 

grafo to erotima etsi

 

$query = 'SELECT idIpotitlou, OnomaTainias, Uploader, ImerominiaUpload, Downloads, EkdosiTainias, Glossa, idTainias FROM `Subtitles` WHERE `OnomaTainias` LIKE CONVERT(_utf8 \'$katigoria%\' USING greek) COLLATE greek_general_ci ORDER BY `ImerominiaUpload` DESC';

 

alla den leitourgi... ti sintaktiko lathos kano??

[random]

php einai ayto? den eimai poly gnwsths...

για να ενωσεις strings πρεπει baleis teleia. να λεει

(_utf8 \' ' . $katigoria . '%\' USING

αντι

(_utf8 \'$katigoria%\' USING

 

i think

[mixalis8]

thanks file.. euxaristo poli...