hjælp til php/mysql
på min side http://www.jokez.frac.dk hvor prøver på atbruge dette joke system or jeg meldingenParse error: parse error in /web/www/frac/users/jokez/index.php on line 9
er det min table eller min index.php kode..?
her er min index.php kode
<?php include("jheader.php"); ?>
<?php
$sql = "select j.joke, j.jokeid from jokes j, admin_control a where a.jotwid = j.jokeid";
$result = mysql_query($sql ,$db)
if ($myrow = mysql_fetch_array($result); {
do {
$jotwid = $myrow["jokeid"];
$jokeoftheweek = $myrow["joke"];
} while ($myrow = mysql_fetch_array($result));
}
$jokepart = substr($jokeoftheweek, 0, 200);
$sql = "select j.jokeid, j.pictype from jokes j, admin_control a where a.potwid = j.jokeid";
$result = mysql_query($sql ,$db);or die(mysql_error());
if ($myrow = mysql_fetch_array($result)) {
do {
$potwid = $myrow["jokeid"];
$pictype = $myrow["pictype"];
} while ($myrow = mysql_fetch_array($result));
}
?>
<table cellpadding=1 border=0 cellspacing=0 width=440>
<tr>
<td bgcolor=<?php printf($sitecolor); ?> align=center>
<table cellpadding=1 border=0 cellspacing=0 width=100% bgColor=#CECECE>
<tr>
<td align=middle colspan=3>
<font size="3" face="tahoma, arial"><b>Jokes of the week</b></font><br>
</td>
</tr>
<tr>
<td width=216 valign=middle align=middle>
<a href="joke.php?id=<?php printf($potwid) ?>"><img src="jokepics/<?php printf($potwid) ?>.<?php printf($pictype) ?>" border=0 width=150></a><br>
<a href="joke.php?id=<?php printf($potwid) ?>"><font size="2" face="tahoma, arial">Click to view</a>
</td>
<td width=8>
</td>
<td width=216>
<table width=200><tr><td>
<p><font size="2" face="tahoma, arial"><?php printf($jokepart) ?><br><a href="joke.php?id=<?php printf($jotwid) ?>">Click to see more...</a></font</p>
</td></tr></table>
</td>
</table>
</td>
</tr>
</table>
<br>
<table cellpadding=1 border=0 cellspacing=0 width=440>
<tr>
<td bgcolor=<?php printf($sitecolor); ?> align=center>
<table cellpadding=1 border=0 cellspacing=0 width=214 bgColor=#CECECE>
<tr>
<td align=middle>
<font size="3" face="tahoma, arial"><b>Newest Jokes</b></font><br>
</td>
</tr>
<?php
$sql = "select * from jokes where type = 'T' and status = 'L' order by jokeid desc limit 10";
$result = mysql_query($sql ,$db);
if ($myrow = mysql_fetch_array($result)) {
do {
printf("<tr>");
printf("<td align=center><font size=2 face='tahoma, arial'><a href=joke.php?id=%s&listtype=1>%s</a></font></td>", $myrow["jokeid"], $myrow["title"]);
printf("</tr>");
} while ($myrow = mysql_fetch_array($result));
}
?>
</table>
</td>
<td width=4>
</td>
<td bgcolor=<?php printf($sitecolor); ?> align=center valign=top>
<table cellpadding=1 border=0 cellspacing=0 width=214 bgColor=#CECECE height=100%>
<tr>
<td align=middle>
<font size="3" face="tahoma, arial"><b>Newest Pictures</b></font><br>
</td>
</tr>
<?php
$sql = "select * from jokes where type = 'P' and status = 'L' order by jokeid desc limit 10";
$result = mysql_query($sql ,$db);
if ($myrow = mysql_fetch_array($result)) {
do {
printf("<tr>");
printf("<td align=center><font size=2 face='tahoma, arial'><a href=joke.php?id=%s&listtype=1>%s</a></font></td>", $myrow["jokeid"], $myrow["title"]);
printf("</tr>");
} while ($myrow = mysql_fetch_array($result));
}
?>
</table>
</td>
</tr>
</table>
<br>
<table cellpadding=1 border=0 cellspacing=0 width=440>
<tr>
<td bgcolor=<?php printf($sitecolor); ?> align=center>
<table cellpadding=1 border=0 cellspacing=0 width=100% bgColor=#CECECE>
<tr>
<td align=middle colspan=3>
<font size="3" face="tahoma, arial"><b>Higest Rated Jokes</b></font><br>
</td>
</tr>
<tr>
<th width=400><font size="3" face="tahoma, arial">Joke</th>
<th width=80><font size="3" face="tahoma, arial">Rating</th>
<th width=120><font size="3" face="tahoma, arial">Date</th>
</tr>
<?php
$sql = "select * from jokes where status = 'L' order by rating desc limit 10";
$result = mysql_query($sql ,$db);
if ($myrow = mysql_fetch_array($result)) {
do {
printf("<tr>");
printf("<td align=center><font size=2 face='tahoma, arial'><a href=joke.php?id=%s&listtype=3>%s</a></font></td>", $myrow["jokeid"], $myrow["title"]);
printf("<td align=center><font size=2 face='tahoma, arial'>%s</font></td>", $myrow["rating"]);
printf("<td align=center><font size=2 face='tahoma, arial'>%s</font></td>", $myrow["date"]);
printf("</tr>");
} while ($myrow = mysql_fetch_array($result));
}
?>
</table>
</td>
</tr>
</table>
<?php include("jfooter.php"); ?>
