Optimering af mysql-kald
Er der ikke nogle der kan hjælpe mig med at optimere mine mysql-kald? her kommer koden:<? require("meta.php"); ?>
<META NAME="Generator" CONTENT="Stone's WebWriter 3.5">
<LINK REL="stylesheet" HREF="junkstyle.css" TYPE="text/css">
<HEAD>
<TITLE>FunnyCartoons.dk - Sjove Flash Film</TITLE>
</HEAD>
<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>
<? require("dropdownbox.php"); ?></td>
</TR>
</TABLE><!-- Indhold Start --><CENTER><BR><!-- BEGIN: AdSolution-Tag 3.1 : DK-home -->
<script type="text/javascript" language="JavaScript" src="http://as1.falkag.de/server/rich.asp?cmd=jsc&dat=46487&xl=468&yl=60&opt=0"></script>
<noscript>
<a href="http://as1.falkag.de/server/poor.asp?cmd=lnk&dat=46487&opt=0" target="_blank"><img src="http://as1.falkag.de/server/poor.asp?cmd=ban&dat=46487&opt=0" width=468 height=60 alt="Klik her!" border=0></a>
</noscript>
<!-- END: AdSolution-Tag 3.1 --></CENTER><TABLE BORDER="0" CELLSPACING="0" CELLPADDING="0">
<TR>
<TD VALIGN="top"><BR STYLE="font-size: 15px"><FONT SIZE="2"> <FONT FACE="Tahoma" SIZE="2">Velkommen til FunnyCartoons.dk!</FONT></FONT><BR><BR STYLE="Font-size: 3px"> <FONT FACE="Tahoma" SIZE="2">Her kan du finde en masse sjove flash film, delt op i kategorier. Der er også mulighed for at sende de <BR> flash film du synes er sjove til dine venner<BR>
<BR> <B>Vælg en kategori</B> Antal Flash Film (<?
$db = mysql_connect("localhost", "blabla", "hemmeligt");
mysql_select_db("funnycartoons", $db);
$g_total = mysql_query("SELECT COUNT(*) as total FROM flash") or die(mysql_error());
while($data = mysql_fetch_array($g_total))
{
echo "$data[total]";
}
?>)<BR STYLE="font-size: 100px"></FONT>
<BR><BR STYLE="font-size: 8px">
<IMG SRC="grafik/speciel_prik.gif" BORDER="0" WIDTH="320" HEIGHT="3" ALIGN="bottom" ALT=""><BR><TABLE BORDER="0" CELLSPACING="1">
<TR>
<TD><TABLE BORDER="0" CELLSPACING="1"CELLSPACING="3">
<TR>
<TD HEIGHT="17%" BGCOLOR="#FFFFFF"><FONT FACE="Tahoma" SIZE="2" COLOR="#000000">» Sjove </FONT></TD>
</TR>
<TR>
<TD><A HREF="visgallery.php?kategori=sjove"><IMG SRC="grafik/forside_hund.gif" BORDER="0" WIDTH="93" HEIGHT="55" ALIGN="bottom" ALT=""></A><BR STYLE="font-size: 2px"><IMG SRC="grafik/pil.gif" BORDER="0" WIDTH="10" HEIGHT="7" ALIGN="bottom" ALT=""><A HREF="visgallery.php?kategori=sjove"><FONT COLOR="#000000">Flash Film<I>(<?
$db = mysql_connect("localhost", "blabla", "hemmeligt");
mysql_select_db("funnycartoons", $db);
$g_total = mysql_query("SELECT COUNT(*) as total FROM flash WHERE kategori= 'sjove'") or die(mysql_error());
while($data = mysql_fetch_array($g_total))
{
echo "$data[total]";
}
?>)</FONT></a></I></TD>
</TR>
</TABLE></TD>
<TD><TABLE BORDER="0" CELLSPACING="1"CELLSPACING="3">
<TR>
<TD HEIGHT="17%" BGCOLOR="#FFFFFF"><FONT COLOR="#FFFFFF"><FONT COLOR="#000000"><FONT FACE="Tahoma" SIZE="2">» Sjove Sange</FONT></FONT></FONT></FONT></TD>
</TR>
<TR>
<TD><A HREF="visgallery.php?kategori=sange"><IMG SRC="grafik/forside_sang.gif" BORDER="0" WIDTH="93" HEIGHT="55" ALIGN="bottom" ALT=""></A><BR STYLE="font-size: 2px"><IMG SRC="grafik/pil.gif" BORDER="0" WIDTH="10" HEIGHT="7" ALIGN="bottom" ALT=""> <A HREF="visgallery.php?kategori=sange"><FONT COLOR="#000000">Flash Film<I>(<?
$db = mysql_connect("localhost", "blabla", "hemmeligt");
mysql_select_db("funnycartoons", $db);
$g_total = mysql_query("SELECT COUNT(*) as total FROM flash WHERE kategori= 'sange'") or die(mysql_error());
while($data = mysql_fetch_array($g_total))
{
echo "$data[total]";
}
?>)</FONT></a></I></TD>
</TR>
</TABLE></TD>
<TD><TABLE BORDER="0" CELLSPACING="1"CELLSPACING="3">
<TR>
<TD HEIGHT="17%" BGCOLOR="#FFFFFF"><FONT COLOR="#FFFFFF"><FONT FACE="Tahoma" SIZE="2" COLOR="#000000">» Parodier</FONT></FONT></FONT></TD>
</TR>
<TR>
<TD><A HREF="visgallery.php?kategori=parodier"><IMG SRC="grafik/forside_parodier.gif" BORDER="0" WIDTH="93" HEIGHT="55" ALIGN="bottom" ALT=""></A><BR STYLE="font-size: 2px"><IMG SRC="grafik/pil.gif" BORDER="0" WIDTH="10" HEIGHT="7" ALIGN="bottom" ALT=""><A HREF="visgallery.php?kategori=parodier"><FONT COLOR="#000000">Flash Film<I>(<?
$db = mysql_connect("localhost", "blabla", "hemmeligt");
mysql_select_db("funnycartoons", $db);
$g_total = mysql_query("SELECT COUNT(*) as total FROM flash WHERE kategori= 'parodier'") or die(mysql_error());
while($data = mysql_fetch_array($g_total))
{
echo "$data[total]";
}
?>)</FONT></a></I></TD>
</TR>
</TABLE></TD>
</TR>
</TABLE><IMG SRC="grafik/prik.gif" BORDER="0" WIDTH="306" HEIGHT="3" ALIGN="bottom" ALT=""><BR><TABLE BORDER="0" CELLSPACING="1">
<TR>
<TD><TABLE BORDER="0" CELLSPACING="1"CELLSPACING="3">
<TR>
<TD HEIGHT="17%" BGCOLOR="#FFFFFF"><FONT COLOR="#FFFFFF"><FONT COLOR="#000000">» <FONT FACE="Tahoma" SIZE="2">Spil</FONT> </FONT></FONT></FONT></TD>
</TR>
<TR>
<TD><A HREF="visgallery.php?kategori=spil"><IMG SRC="grafik/forside_spil.gif" BORDER="0" WIDTH="93" HEIGHT="55" ALIGN="bottom" ALT=""></A><BR STYLE="font-size: 2px"><IMG SRC="grafik/pil.gif" BORDER="0" WIDTH="10" HEIGHT="7" ALIGN="bottom" ALT=""><A HREF="visgallery.php?kategori=spil"><FONT COLOR="#000000">Flash Film<I>(<?
$db = mysql_connect("localhost", "blabla", "hemmeligt");
mysql_select_db("funnycartoons", $db);
$g_total = mysql_query("SELECT COUNT(*) as total FROM flash WHERE kategori= 'spil'") or die(mysql_error());
while($data = mysql_fetch_array($g_total))
{
echo "$data[total]";
}
?>)</FONT></a></I></TD>
</TR>
</TABLE></TD>
<TD><TABLE BORDER="0" CELLSPACING="1"CELLSPACING="3">
<TR>
<TD HEIGHT="17%" BGCOLOR="#FFFFFF"><FONT COLOR="#FFFFFF"><FONT COLOR="#000000">» <FONT FACE="Tahoma" SIZE="2">Bin Laden</FONT></FONT></FONT></FONT></TD>
</TR>
<TR>
<TD><A HREF="visgallery.php?kategori=osama"><IMG SRC="grafik/forside_osama.gif" BORDER="0" WIDTH="93" HEIGHT="55" ALIGN="bottom" ALT=""></A><BR STYLE="font-size: 2px"><IMG SRC="grafik/pil.gif" BORDER="0" WIDTH="10" HEIGHT="7" ALIGN="bottom" ALT=""><A HREF="visgallery.php?kategori=osama"><FONT COLOR="#000000">Flash Film<I>(<?
$db = mysql_connect("localhost", "blabla", "hemmeligt");
mysql_select_db("funnycartoons", $db);
$g_total = mysql_query("SELECT COUNT(*) as total FROM flash WHERE kategori= 'osama'") or die(mysql_error());
while($data = mysql_fetch_array($g_total))
{
echo "$data[total]";
}
?>)</FONT></a></I></TD>
</TR>
</TABLE></TD>
<TD><TABLE BORDER="0" CELLSPACING="1"CELLSPACING="3">
<TR>
<TD HEIGHT="17%" BGCOLOR="#FFFFFF"><FONT COLOR="#FFFFFF"><FONT COLOR="#000000"><FONT FACE="Tahoma" SIZE="2">» Frække</FONT></FONT></FONT></FONT></TD>
</TR>
<TR>
<TD><A HREF="visgallery.php?kategori=sexede"><IMG SRC="grafik/forside_fraekke.gif" BORDER="0" WIDTH="93" HEIGHT="55" ALIGN="bottom" ALT=""></A><BR STYLE="font-size: 2px"><IMG SRC="grafik/pil.gif" BORDER="0" WIDTH="10" HEIGHT="7" ALIGN="bottom" ALT=""><A HREF="visgallery.php?kategori=sexede"><FONT COLOR="#000000">Flash Film<I>(<?
$db = mysql_connect("localhost", "blabla", "hemmeligt");
mysql_select_db("funnycartoons", $db);
$g_total = mysql_query("SELECT COUNT(*) as total FROM flash WHERE kategori= 'sexede'") or die(mysql_error());
while($data = mysql_fetch_array($g_total))
{
echo "$data[total]";
}
?>)</FONT></a></I></TD>
</TR>
</TABLE></TD>
</TR>
</TABLE><IMG SRC="prik.gif" BORDER="0" WIDTH="306" HEIGHT="3" ALIGN="bottom" ALT=""><BR>
<SCRIPT>
<!--
function Validering(eform)
{
if (""==eform.ord.value)
{
window.alert("Du mangler at indtaste et ord!");
return false;
}
return true;
}
-->
</SCRIPT>
<TABLE BORDER="0" CELLSPACING="0" CELLPADDING="0">
<TR>
<TD><TABLE WIDTH="225" BORDER="0" CELLSPACING="1" CELLPADDING="2">
<TR>
<TD><IMG SRC="grafik/lilleprik.gif" BORDER="0" WIDTH="225" HEIGHT="3" ALIGN="bottom" ALT=""><BR><BR STYLE="font-size: 5px"><FONT FACE="Tahoma" SIZE="2"><B>Søg efter Flash Film</B><BR></FONT><FONT FACE="Tahoma" SIZE="1">Kan du ikke lige finde den flash film du leder efter? Prøv at søge blandt alle vores flash film. Skriv et eller flere ord i boksen nedenunder. <form method="post" onSubmit="return Validering(this);" action="search.php">
<INPUT TYPE="text" SIZE="40" NAME="ord">
<input type="submit" name="Submit" value="Søg">
</FONT></TD>
</TR>
</TABLE></TD>
<TD VALIGN="bottom"><IMG SRC="grafik/part1.jpg" BORDER="0" WIDTH="87" HEIGHT="102" ALIGN="bottom" ALT=""></TD>
</TR>
</TABLE>
<TABLE BORDER="0" CELLSPACING="0" CELLPADDING="0">
<TR>
<TD><TABLE BORDER="0" CELLSPACING="0" CELLPADDING="0">
<TR>
<TD><CENTER><BR STYLE="font-size: 6px"><IMG SRC="grafik/lilleprik.gif" BORDER="0" WIDTH="225" HEIGHT="3" ALIGN="bottom" ALT=""><BR><BR STYLE="font-size: 5px"><IMG SRC="grafik/highscores.jpg" BORDER="0" WIDTH="101" HEIGHT="24" ALIGN="bottom" ALT=""></CENTER><TABLE WIDTH="225" BORDER="0" CELLPADDING="2">
<?
$l=1;
$db = mysql_connect("localhost", "blabla", "hemmeligt");
mysql_select_db("funnycartoons", $db);
$foresp = mysql_query("SELECT total, spillersemail, spillersnavn FROM highscore ORDER BY total DESC LIMIT 0, 5") or die (mysql_error());
while($data = mysql_fetch_array($foresp))
{
echo "<TR>
<TD><FONT FACE=Tahoma SIZE=2 COLOR=#000000>$l. <U><A HREF=mailto:$data[spillersemail]>$data[spillersnavn]</FONT></A></U></TD>
<TD ALIGN=right><B><FONT FACE=Tahoma SIZE=2>$data[total] points</FONT></B></font></TD>
</TR>";
$l=$l+1;
}
?>
<BR STYLE="font-size: 5px">
</TABLE></TD>
</TR>
</TABLE><BR STYLE="font-size: 19px">
<CENTER><CENTER><FONT FACE="Tahoma" SIZE="2">Spil <A HREF="visspil.php">Skydespillet</A> og kom på top 5</FONT></CENTER></CENTER></TD>
<TD VALIGN="top"> <IMG SRC="grafik/part2.jpg" BORDER="0" WIDTH="88" HEIGHT="195" ALIGN="bottom" ALT=""></TD>
</TR>
</TABLE>
</TD>
<TD VALIGN="top"><!-- Højre Række Start --><BR><IMG SRC="grafik/aber.gif" BORDER="0" WIDTH="217" HEIGHT="131" ALIGN="bottom" ALT=""><BR><BR STYLE="font-size: 4px"><FONT FACE="Tahoma" SIZE="2"><CENTER><B>De 10 Nyeste Flash Film</B></CENTER></FONT><BR STYLE="font-size: 7px"><?
$db = mysql_connect("localhost", "blabla", "hemmeligt");
mysql_select_db("funnycartoons", $db);
$foresp = mysql_query("SELECT titel, id, dato FROM flash ORDER BY dato DESC LIMIT 0, 10") or die (mysql_error());
while($data = mysql_fetch_array($foresp))
{
echo "» <A HREF=http://www.funnycartoons.dk/visflashfilm.php?id=$data[1] class=a>$data[0]</A>";
echo "<BR>";
}
?><BR STYLE="font-size: 12px"><IMG SRC="grafik/box.gif" BORDER="0" WIDTH="219" HEIGHT="5" ALIGN="bottom" ALT=""><BR><BR STYLE="font-size: 8px"><CENTER><?
$db = mysql_connect("localhost", "blabla", "hemmeligt");
mysql_select_db("funnycartoons", $db);
$foresp = mysql_query("SELECT id, billede, kategori, titel FROM flash ORDER BY rand() limit 3") or die (mysql_error());
while($data = mysql_fetch_array($foresp))
{
echo "<a href='visflashfilm.php?id=$data[id]'>";
echo "<img src=flash/billeder/$data[kategori]/$data[billede] border=0 width=111 height=71 alt=$rows[titel]><BR><FONT FACE=tahoma SIZE=2>$data[titel]</FONT></a><BR><BR STYLE=\"font-size: 11px\">";
}
?>
</CENTER><!-- Højre Række Slut --></TD>
</TR>
</TABLE>
<!-- Indhold Slut --><BR><? require("links.php"); ?></TD>
</TR>
</TABLE>
<BR STYLE="font-size: 3px">
<FONT FACE="Tahoma" SIZE="1" COLOR="#CAE2F4">© 2002 <A HREF="mailto:lasse.kristensen@c.dk"><FONT COLOR="#CAE2F4">FunnyCartoons.dk</FONT></A></FONT><BR><BR STYLE="font-size: 3px">
</BODY>
</HTML></CENTER>
