optimering af mysql-kald
Nogen der kan hjælpe mig med at optimere mine sql-kald?<? require("meta.php"); ?><LINK REL="stylesheet" HREF="junkstyle.css" TYPE="text/css"><CENTER><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN">
<HTML>
<HEAD>
<?
$db = mysql_connect("localhost", "hemmeligt", "hemmeligt");
mysql_select_db("funnycartoons", $db);
$res = mysql_query("select kategori, url, height, width, titel, dato from flash where id = '$id'");
$row = mysql_fetch_array($res);
?> <TITLE>FunnyCartoons.dk - Flash Film: <? echo $row[titel]; ?></TITLE>
<CENTER>
<BODY BGCOLOR="#2896D7" topmargin="0" leftmargin="0"><BR><BR><CENTER><? require("toplogo.php"); ?>
<TABLE WIDTH="500" HEIGHT="100%" BORDER="0" BGCOLOR="#FFFFFF" CELLSPACING="1">
<TR>
<TD VALIGN="top"><TABLE WIDTH="547" HEIGHT="15" BORDER="0" BGCOLOR="#38B5FF" CELLSPACING="1">
<TR>
<TD VALIGN="top"><A HREF="http://www.funnycartoons.dk"><IMG SRC="grafik/top1.gif" BORDER="0" WIDTH="268" HEIGHT="22" ALIGN="bottom" ALT=""></A></TD>
<td><FONT FACE="Tahoma" SIZE="2" COLOR="#FFFFFF"><B>Kategorier:</B></FONT>
</td>
</TR>
</TABLE><!-- Indhold Start --><BR><CENTER><? require("adpepper_misc.php"); ?></CENTER>
<!-- Vis Flash Film Start --><CENTER><BR STYLE="font-size: 4px"><? if (!$id) {
echo "<BR><BR><BR><BR><BR><BR><BR><BR><FONT FACE=Tahoma SIZE=2>Du har ikke valgt nogen flashfilm! Tryk <A HREF=http://www.funnycartoons.dk/index1.php>HER</A> for at komme tilbage.</FONT><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR>";
}
else
{
?><FONT FACE="Tahoma" SIZE="2">Det kan godt tage et stykke tid at downloade flash filmen</FONT><BR><BR STYLE="font-size: 6px"><?
echo "<embed src=http://www.funnycartoons.dk/flash/$row[url] pluginspage=http://www.macromedia.com/shockwave/download/ HEIGHT=450 WIDTH=540 type=application/x-shockwave-flash quality=best></embed></A>";
?><BR><BR><FONT FACE="Tahoma" SIZE="2"></FONT><BR><font size=1 face=tahoma><SCRIPT LANGUAGE="JavaScript">
<!-- <!-- Begin
function goToURL() {
window.open( "send_flash_film.php?id=<? echo $id; ?>", "Anbefal", "height=500, width=225" );
}
// End
-->
</script>
<form>
<input type=button value="» Klik her for at sende denne flash film til en ven!" onClick="goToURL()">
</form><BR><BR><FONT FACE="Tahoma" SIZE="2">
<?
$pos = strpos($HTTP_REFERER, "funnycartoons");
if ($pos === false) { // note: three equal signs
echo "<a href=visgallery.php?kategori=$row[kategori]><IMG SRC=grafik/tilbage.jpg BORDER=0 WIDTH=83 HEIGHT=27 ALIGN=bottom ALT=></a>";
}
else {
echo "<a href=java script:history.go(-1)><IMG SRC=grafik/tilbage.jpg BORDER=0 WIDTH=83 HEIGHT=27 ALIGN=bottom ALT=></a>";
}
?>
</FONT><BR><BR><IMG SRC="grafik/lilleprik.gif" BORDER="0" WIDTH="225" HEIGHT="3" ALIGN="bottom" ALT=""><IMG SRC="grafik/speciel_prik.gif" BORDER="0" WIDTH="320" HEIGHT="3" ALIGN="bottom" ALT=""><BR>
<FONT FACE="Tahoma" SIZE="2"><B>Titel:</B> <? echo $row[titel]; ?></FONT> <FONT FACE="Tahoma" SIZE="2"><B>Kategori:</B> <? echo $row[kategori]; ?></FONT> <FONT FACE="Tahoma" SIZE="2"><B>Oprettet:</B> <? echo date("j/n - Y", $row[dato]); ?></FONT><BR><IMG SRC="grafik/lilleprik.gif" BORDER="0" WIDTH="225" HEIGHT="3" ALIGN="bottom" ALT=""><IMG SRC="grafik/speciel_prik.gif" BORDER="0" WIDTH="320" HEIGHT="3" ALIGN="bottom" ALT=""><BR></CENTER>
<!-- Vis Billede Slut! --><? }?><BR><? require("links.php"); ?><BR><BR></TD>
</TR>
</TABLE>
<BR>
</BODY>
</HTML></CENTER>
