hjælp til link fra database
Hejsa jeg har et problem hvor der at jeg skal vise kategorier og så vise hvad der i den enkelte side,, :)kan ikke få det helt til at funger..
det virker helt indtil at elseif sætiningen i scriptet ( som er for neden )
selve siden hvor jeg ikke kan få det til funger er her:
------------------siden--------------------------------
<?
if (!$_GET["page"]) {
$query = mysql_query ("SELECT * FROM `frettir` ORDER BY dags") or die(mysql_error());
while ($rs = mysql_fetch_array($query)){
echo "<b />".$rs['dags']."</b> | <a href='?page=frett&id=".$rs['id']."'>".$rs['title']."</a><br />";
}
}
elseif($_GET["page"] =="frett") {
$query = mysql_query ("SELECT * FROM `frettir` WHERE `id` = '$_GET[id]'") or die(mysql_error());
while ($rs = mysql_fetch_array($query)){
echo"
<table>
<tr>
<td>".$rs['title']." -".$rs['dags']." ".$rs['klukkan']."</td></tr>
<tr>
<td>";
{
$post = $rs['post'];
$post = preg_replace('#\[url\surl="(.+)"\](.+)\[\/url\]#i', '<a target="_blank" href="http://$1">$2</a>', $post);
$post = preg_replace('#\[email](.+)\[\/email\]#i', '<a href="mailto:$1">$1</a>', $post);
$post = preg_replace("/\\[(\/?(?:b|i|u))]/i", "<\$1>", $post);
$search = array("[code]", "[/code]", "[quote]", "[/quote]");
$replace = array("<table style=\"background-color: #666666;\"><tr><td>", "</td></tr></table>", "Quote: \"", "\"");
$post = str_replace($search, $replace, $post);
$post = preg_replace("/\[url\](\S+)\[\/url\]/i","<a href=\"http://\\1\" target=\"_blank\">\\1</a>",$post);
$post = preg_replace("/\[img\](\S+)\[\/img\]/i","<a href=\"\\1\" target=\"_blank\">\\1</a>",$post);
$post = nl2br($post);
echo $post;
}
echo"</td></tr></table>";
echo"<br /><a href='?page'>Til baka</a>";
}
}
elseif($_GET["page"] =="stadan") {
?>
<table>
<tr>
<td><?$query = mysql_query ("SELECT * FROM `stadan` WHERE `id` ='1'") or die(mysql_error());
while ($rs = mysql_fetch_array($query)){ echo"<a href='?page=view&id=".$rs['id']."'>".$rs['deild']."</a>"; }?></td></tr>
<tr /><td><?$query = mysql_query ("SELECT * FROM `stadan` WHERE `id` ='2'") or die(mysql_error());
while ($rs = mysql_fetch_array($query)){ echo"<a href='?page=view&id=".$rs['id']."'>".$rs['deild']."</a>"; }?></td></tr>
<tr>
<td><?$query = mysql_query ("SELECT * FROM `stadan` WHERE `id` ='3'") or die(mysql_error());
while ($rs = mysql_fetch_array($query)){ echo"<a href='?page=view&id=".$rs['id']."'>".$rs['deild']."</a>"; }?></td></tr>
<tr /><td><?$query = mysql_query ("SELECT * FROM `stadan` WHERE `id` ='4'") or die(mysql_error());
while ($rs = mysql_fetch_array($query)){ echo"<a href='?page=view&id=".$rs['id']."'>".$rs['deild']."</a>"; }?></td></tr>
<tr>
<td><?$query = mysql_query ("SELECT * FROM `stadan` WHERE `id` ='5'") or die(mysql_error());
while ($rs = mysql_fetch_array($query)){ echo"<a href='?page=view&id=".$rs['id']."'>".$rs['deild']."</a>"; }?></td></tr>
<tr /><td><?$query = mysql_query ("SELECT * FROM `stadan` WHERE `id` ='6'") or die(mysql_error());
while ($rs = mysql_fetch_array($query)){ echo"<a href='?page=view&id=".$rs['id']."'>".$rs['deild']."</a>"; }?></td>
</td></tr></table>
<?
}
elseif ($_GET["page"] =="view") {
$query = mysql_query ("SELECT * FROM `stadan` WHERE `id` ='$_GET[id]'") or die(mysql_error());
while ($rs = mysql_fetch_array($query)){
?>
<table><tr><td>
<?echo "".$rs['deild']."";?></td></tr>
<tr><td><? echo "".$rs['text'].""; ?></td></tr></table>
<? } ?>
<br /><a href="?page=stadan">Til baka</a>
<?
}
elseif ($_GET["page"] =="1kvk") { ?>
<table style="width: 400px;">
<tr>
<td><?$query = mysql_query ("SELECT * FROM `stig` WHERE `id` ='6'") or die(mysql_error());
while ($rs = mysql_fetch_array($query)){ echo"<a href='?page=stig&id=".$rs['id']."'>".$rs['lid']."</a>"; }?></td>
<td><?$query = mysql_query ("SELECT * FROM `stig` WHERE `id` ='7'") or die(mysql_error());
while ($rs = mysql_fetch_array($query)){ echo"<a href='?page=stig&id=".$rs['id']."'>".$rs['lid']."</a>"; }?></td>
<td><?$query = mysql_query ("SELECT * FROM `stig` WHERE `id` ='8'") or die(mysql_error());
while ($rs = mysql_fetch_array($query)){ echo"<a href='?page=stig&id=".$rs['id']."'>".$rs['lid']."</a>"; }?></td>
<td><?$query = mysql_query ("SELECT * FROM `stig` WHERE `id` ='9'") or die(mysql_error());
while ($rs = mysql_fetch_array($query)){ echo"<a href='?page=stig&id=".$rs['id']."'>".$rs['lid']."</a>"; }?></td></tr>
</table>
<br />
<table /><tr /><td />Allar upplýsingar um stig leikmanna er tekið af <a href="http://bli.is" target="_blank">bli.is</a></td></tr></table>
<?
}
elseif ($_GET["page"] =="1kk") {
?>
<table style="width: 400px;">
<tr>
<td><?$query = mysql_query ("SELECT * FROM `stig` WHERE `id` ='1'") or die(mysql_error());
while ($rs = mysql_fetch_array($query)){ echo"<a href='?page=stig&id=".$rs['id']."'>".$rs['lid']."</a>"; }?></td>
<td><?$query = mysql_query ("SELECT * FROM `stig` WHERE `id` ='2'") or die(mysql_error());
while ($rs = mysql_fetch_array($query)){ echo"<a href='?page=stig&id=".$rs['id']."'>".$rs['lid']."</a>"; }?></td>
<td><?$query = mysql_query ("SELECT * FROM `stig` WHERE `id` ='3'") or die(mysql_error());
while ($rs = mysql_fetch_array($query)){ echo"<a href='?page=stig&id=".$rs['id']."'>".$rs['lid']."</a>"; }?></td>
<td><?$query = mysql_query ("SELECT * FROM `stig` WHERE `id` ='4'") or die(mysql_error());
while ($rs = mysql_fetch_array($query)){ echo"<a href='?page=stig&id=".$rs['id']."'>".$rs['lid']."</a>"; }?></td>
<td><?$query = mysql_query ("SELECT * FROM `stig` WHERE `id` ='5'") or die(mysql_error());
while ($rs = mysql_fetch_array($query)){ echo"<a href='?page=stig&id=".$rs['id']."'>".$rs['lid']."</a>"; }?></td>
</tr><br />
</table>
<br />
<table /><tr /><td />Allar upplýsingar um stig leikmanna er tekið af <a href="http://bli.is" target="_blank">bli.is</a></td></tr></table>
<?
}
elseif ($_GET["page"] =="stig") {
$query = mysql_query ("SELECT * FROM `stig` WHERE `id` ='$_GET[id]'") or die(mysql_error());
while ($rs = mysql_fetch_array($query)){
?>
<table />
<tr />
<td /><?echo ''.$rs['text'].'';?></td>
</tr>
</table>
<?
}
}
elseif($_GET["page"] =="um") {
$query = mysql_query ("SELECT * FROM `um` ORDER BY `id`") or die(mysql_error());
while ($rs = mysql_fetch_array($query)){
echo "
<table />
<tr />
<td / style='text-align: center;'><b />".$rs['title']."</b></td></tr>
<tr /><td />".$rs['post']."</td></tr></table>";
}
}
elseif($_GET["page"] =="tenglar") {
-----------------------------------
her vil jeg gerne have puttet scriptet ind i som er for neden
---------------------------------------
}
?>
--------------siden slut----------------------------
her er selve scriptet:
-------------------------------------------------
include("conn.php");
if (($i%3)== 0) {
echo "<tr> </tr>";
}
if (!isset($_GET['action'])) {
$conn = mysql_query("SELECT * FROM flokkar ORDER BY id DESC") or die (mysql_error());
while ($rs = mysql_fetch_array($conn)) {
print('<a href="?action=kategori&kat='.$rs['flokkur'].'">'.$rs['flokkur'].'</a><br><br>');
}
} elseif ($_GET['action'] == "kategori") {
$conn = mysql_query("SELECT * FROM tenglar WHERE flokkur = '$_GET[kat]'");
while ($rs = mysql_fetch_array($conn)) {
print('<a href="http://'.$rs['tengill'].'" target="_blank">'.$rs['nafn'].'</a><br>');
}
}
--------------------------------------------------------
