Hello
Anyone know how I can change the following script so that it displays only results starting with the letter "A" ordered ascending by the coloumn "tittel"?
<?php
//Logon to database
$db = mysql_connect("localhost", "username", "password");
mysql_select_db("database",$db);
$result = mysql_query("SELECT * FROM tbl_film1 ORDER BY tittel ASC",$db);
if ($myrow = mysql_fetch_array($result)) {
do {
printf("<div id=\"terning1\" style=\"float: left\"><img src=\"innhold/bilder/terning/%s\"></div><div id=\"vissiste2\" align=\"left\" style=\"float: left\"><a href=\"%s\" target=\"blank\" title=\"IMDB.com\"><b>%s</b></a><br><b>%s,<br>%s år</b></div><div id=\"img1\" style=\"float: right\"><img src=\"innhold/bilder/%s\"></div><br><br><br><div id=\"vissiste3\" align=\"left\" style=\"float: none;\">%s</div><br><br><div id=\"vissiste4\" align=\"left\" style=\"float: none;\"><div id=\"vurdering\">Min vurdering:</div><br>%s</div><hr color=\"#000000\"><br>\n",
$myrow["terning"], $myrow["link"], $myrow["tittel"], $myrow["genre"], $myrow["alder"], $myrow["img"], $myrow["beskrivelse"], $myrow["omtale"]);
} while ($myrow = mysql_fetch_array($result));
} else {
echo "Sorry, couldn't find anything!";
}
?>
