Avatar billede funnycartoons-dk Nybegynder
20. august 2002 - 10:57 Der er 5 kommentarer og
1 løsning

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>&nbsp;&nbsp;
<? 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">&nbsp;<FONT FACE="Tahoma" SIZE="2">Velkommen til FunnyCartoons.dk!</FONT></FONT><BR><BR STYLE="Font-size: 3px">&nbsp;<FONT FACE="Tahoma" SIZE="2">Her kan du finde en masse sjove flash film, delt op i &nbsp;kategorier.&nbsp;Der er også mulighed for at sende de <BR>&nbsp;flash film du synes er sjove til dine venner<BR>
<BR>&nbsp;<B>Vælg en kategori</B>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;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">&nbsp;<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">&copy; 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>
Avatar billede sone Nybegynder
20. august 2002 - 11:00 #1
...skal vi så bare selv gætte hvad du ønsker optimeret?
Avatar billede jakoba Nybegynder
20. august 2002 - 11:50 #2
det er mysql kaldene der skal optimeres. Så alt udenfor php klammerne <? og ?> kan vi roligt fjerne. evt echo af konstante værdier kan vi også klippe fra.

desværre er det hele rodet sammen i en pærevællign uden antydning af indrykninger eller anden struktur til at gøre koden overskuelig så det kan være det varer lidt før der kommer en forbi der gider.
Avatar billede coderdk Praktikant
20. august 2002 - 12:18 #3
Hvad med at han selv hiver SQL'en ud en efter en og stiller dem nummereret op :P Jeg gider ikke engang kigge efter SQL'en i den kode... :P
Avatar billede jakoba Nybegynder
20. august 2002 - 12:51 #4
Jeg gad pille den ud. Nu får vi se om han gidder sætte den ind igen de rigtige steder:

<? require("meta.php"); ?>
<? require("toplogo.php"); ?>
<? require("dropdownbox.php"); ?>
<?
$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]";
}
?>
<?
$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]";
}
?>
<?
$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]";
}
?>
<?
$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]";
}
?>
<?
$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]";
}
?>
<?
$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]";
}
?>
<?
$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]";
}
?>
<?
$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;
}
?>
<?
$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>";
}
?>
<?
$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\">";
}
?>
<? require("links.php"); ?>

---------------  nu er det til at overskue :-)) --------------------

Når du een gang har connectet til mysql og åbnet din database vil den konnection stå åben indtil du lukker den igen med  mysql_close( $db ).

I alle de der udtræk med "SELECT COUNT(*) as total FROM flash ..." VED vi at der kun kommer een række med eet tal tilbage. det er lidt fjollet at bruge en while sætning for at få det ene tal skrevet.

Du kan måske spare en del tid ved at hente totalen for alle 6 kategorier på een gang, men det bliver mere komploceret kode:
derefter kan du udskrive de enkelte totaler ved at indexere med kategorinavnet:
echo $totaler['sjove'];  // udskriver antal film i kategorien 'sjove'

det bliver så:

<? require("meta.php"); ?>
<? require("toplogo.php"); ?>
<? require("dropdownbox.php"); ?>
<?
$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());
echo mysql_result( $g_total, 0, 0 );  //skriv første tal i første række af resultatet
?>
<?
$g_total = mysql_query("SELECT COUNT(*) as total, kategori FROM flash GROUP BY kategori") or die(mysql_error());
$totaler = array();
while ( $row = mysql_fetch_array( $g_total ) {
    $totaler[ $row['kategori'] ] = $row['total'];
}
echo $totaler['sjove'];
?>
<?
echo $totaler['sange'];
?>
<?
echo $totaler['parodier'];
?>
<?
echo $totaler['spil'];
?>
<?
echo $totaler['osama'];
?>
<?
echo $totaler['sexede'];
?>
<?
$l=1;
$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;
}
?>
<?
$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>";
}
?>
<?
$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\">";
}
?>
<? require("links.php"); ?>

mvh JakobA
Avatar billede funnycartoons-dk Nybegynder
20. august 2002 - 14:09 #5
Hej Jakoba. Jeg har gjort nøjagtig som du har sagt (og tak for det =)) Men den giver en parse fejl.. http://www.funnycartoons.dk/index2.php

Her er kildekoden med parse fejlen:

<? 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>&nbsp;&nbsp;
<? 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">&nbsp;<FONT FACE="Tahoma" SIZE="2">Velkommen til FunnyCartoons.dk!</FONT></FONT><BR><BR STYLE="Font-size: 3px">&nbsp;<FONT FACE="Tahoma" SIZE="2">Her kan du finde en masse sjove flash film, delt op i &nbsp;kategorier.&nbsp;Der er også mulighed for at sende de <BR>&nbsp;flash film du synes er sjove til dine venner<BR>
<BR>&nbsp;<B>Vælg en kategori</B>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Antal Flash Film (<?
$db = mysql_connect("localhost", "ss", "ssss");
mysql_select_db("funnycartoons", $db);
$g_total = mysql_query("SELECT COUNT(*) as total FROM flash") or die(mysql_error());
echo mysql_result( $g_total, 0, 0 );  //skriv første tal i første række af resultatet
?>
)<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>(<?
$g_total = mysql_query("SELECT COUNT(*) as total, kategori FROM flash GROUP BY kategori") or die(mysql_error());
$totaler = array();
while ( $row = mysql_fetch_array( $g_total ) {
    $totaler[ $row['kategori'] ] = $row['total'];
}
echo $totaler['sjove'];
?>)</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>(<? echo $totaler['sange']; ?>)</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>(<? echo $totaler['parodier']; ?>)</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>(<? echo $totaler['spil']; ?>)</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>(<? echo $totaler['osama']; ?>)</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>(<? echo $totaler['sexede']; ?>)</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;
$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">&nbsp;<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"><?
$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><?
$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">&copy; 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>
Avatar billede funnycartoons-dk Nybegynder
20. august 2002 - 14:17 #6
har rettet fejlen
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Vi tilbyder markedets bedste kurser inden for webudvikling

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester