hi! first of all my big problem is my alphabet which is central european. we have a letter 'LJ' that is actually just one letter. so when i run query on a letter 'L' i want to display all records that start with L and not with LJ. i have done this like this:
// connection stuff
$select_letter = $_GET['letter'];
if ($select_letter="L") {
$query = mysql_query("SELECT * FROM filmovi WHERE title_hr LIKE 'L%' AND title_hr NOT LIKE 'LJ%' ORDER BY title_hr");
}
else {
$query = mysql_query("SELECT * FROM filmovi WHERE title_hr LIKE '$select_letter%' ORDER BY title_hr");
}
while($row = mysql_fetch_array($query)) {
//other stuff
and now everytime i load that page query is always the first one. i can't run second query when i click on a letter that is not 'L'. i know that mysql query is good so i think that problem is somewhere in php... PLEASE F1!
