Avatar billede grise_bassen Nybegynder
01. september 2004 - 18:06 Der er 11 kommentarer og
1 løsning

hjælp til php/mysql

på min side http://www.jokez.frac.dk hvor prøver på atbruge dette joke system or jeg meldingen

Parse 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"); ?>
Avatar billede grise_bassen Nybegynder
01. september 2004 - 18:08 #1
" hvor jeg prøver at bruge dette joke system http://frip.dk/grisen/joke.zip "
Avatar billede web-geek Nybegynder
01. september 2004 - 18:13 #2
<?php include("jheader.php"); ?>

<?php 

$result = mysql_query("SELECT * FROM jokes") ;

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"); ?>
Avatar billede grise_bassen Nybegynder
01. september 2004 - 18:17 #3
det hjælp ikke
Avatar billede grise_bassen Nybegynder
01. september 2004 - 18:21 #4
hvis du gider kan du give mig din mail. så sender jeg mit pass til frac og så kan du rette min fejl?
Avatar billede hmortensen Nybegynder
01. september 2004 - 18:24 #5
Jeg har ikke kigget hele din kode igennem, men fandt et par fejl i starten:

<?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) {
    while ($myrow = mysql_fetch_array($result)) {
        $jotwid = $myrow["jokeid"];
        $jokeoftheweek = $myrow["joke"];
    }
}

$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)) {
    while ($myrow = mysql_fetch_array($result)) {
        $potwid = $myrow["jokeid"];
        $pictype = $myrow["pictype"];
    }
}

?>

<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)) {
    while ($myrow = mysql_fetch_array($result)) {
        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>");
    }
}

?>

</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)) {
    while ($myrow = mysql_fetch_array($result)) {
        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>");
    }
}

?>

</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)) {
    while ($myrow = mysql_fetch_array($result)) {
        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>");
    }
}

?>
</table>
</td>
</tr>
</table>

<?php include("jfooter.php"); ?>
Avatar billede web-geek Nybegynder
01. september 2004 - 19:48 #6
Min e-mail er deep4ck@yahoo.dk send dit pass, så ordner jeg det.
Avatar billede grise_bassen Nybegynder
02. september 2004 - 15:12 #7
jeg har sendt min kod og brugernavn til dig... så bare si når du har fixed det.. og tak
Avatar billede grise_bassen Nybegynder
02. september 2004 - 19:57 #8
hva´så ved du hvad der galdt?
Avatar billede hmortensen Nybegynder
03. september 2004 - 08:09 #9
Har du prøvet den løsning jeg har smidt ?
Avatar billede grise_bassen Nybegynder
03. september 2004 - 11:16 #10
ja men det virkede ikk
Avatar billede hmortensen Nybegynder
03. september 2004 - 11:25 #11
Hvad får du af fejl ?

Vil være lidt lettere hvis du kom med noget feedback, eller ønsker du ikke at få løst dit problem ?
Avatar billede grise_bassen Nybegynder
03. september 2004 - 13:01 #12
lige meget
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