lidt php (og evt. mysql?) hjælp
Hello folkens, mit spg. er som flg.Jeg vi godt have indholdet fra en tabel/række i MySQL db over i en kasse men, nu kommer det tricky, det skal gøre når jeg trykke på et link på den samme side... hvis i forstår, men lortet gør ik som jeg vil :) se selv: www.coolart.dk/juv2
anyway her er koden på siden:
<?
include("connect.php");
?>
<html>
<head>
<title>Homepage of Juveniles</title>
<style>
<!--
a:link{color: #000000;text-decoration: none;}
a:visited{color: #000000;text-decoration: none;}
a:active{color: #000000;text-decoration: none;}
a:hover{color: #481800text-decoration: none;}
-->
</style>
</head>
<body bgcolor="#A6A6A6" text="#000000" LEFTMARGIN=0 TOPMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0>
<table width="776" height="115" border="0" cellspacing="0" cellpadding="0">
<tr>
<td background="top2.jpg" height="115"> </td>
<td height="115" width="2" bgcolor="000000"></td>
</tr>
</table>
<table width="776" border="0" cellspacing="0" cellpadding="0">
<tr>
<td background="toptxt.jpg" width="198" height="34"></td>
<td bgcolor="A6A6A6" width="576" height="34" valign="bottom"><font face="verdana" size="2">
<b>News - About - Members - Clanwars - Tagwall - <a href="login.php">Admin</a></b></font></td>
<td height="34" width="2" bgcolor="000000"></td>
</tr>
</table>
<table width="776" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="000000" height="2"></td>
<td height="2" width="2" bgcolor="000000"></td>
</tr>
</table>
<table width="776" bgcolor="C44100" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="356" width="459" valign="top" align="center"><br>
<table width="449" border="0" cellspacing="0" cellpadding="0" height="46">
<tr>
<td background="newstop.jpg" height="46"> </td>
</table>
<table width="449" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="10" background="spacel.jpg" height="418"> </td>
<td height="418" valign="top"><?
$query = mysql_query("SELECT * FROM members") OR DIE(mysql_error());
while($row = mysql_fetch_array($query)) {
?><br>
Js|<a href="members.php?members=<?=$row['csnick'];?>"><?=$row['csnick'];?></a>
<br>
<br><?
}
?></td>
<td width="13" background="spacer.jpg" height="418"> </td>
</tr>
</table>
<table width="449" border="0" cellspacing="0" cellpadding="0">
<tr>
<td background="newsbottom.jpg" height="8"></td>
</tr>
</table>
</td>
<td height="356" width="316" valign="top" align="center"><br>
<table width="306" height="42" border="0" cellspacing="0" cellpadding="0">
<tr>
<td background="blatop.jpg"> </td>
</tr>
</table>
<table width="306" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="10" background="spacel.jpg" height="101"> </td>
<td height="101"> </td>
<td width="13" background="spacer.jpg" height="101"> </td>
</tr>
</table>
<table width="306" border="0" cellspacing="0" cellpadding="0">
<tr>
<td background="blabottom.jpg" height="8"></td>
</tr>
</table>
<br>
<table width="306" height="42" border="0" cellspacing="0" cellpadding="0">
<tr>
<td background="blatop2.jpg"> </td>
</tr>
</table>
<table width="306" height="191" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="10" background="spacel.jpg" height="191"> </td>
<td height="191" valign="top" bgcolor="C54100"><?
if (isset($_GET['member'])) {
$member = $_GET['member'];
?>
<?
$query = mysql_query("SELECT * members WHERE csnick = '$member'") ;
?>
<br>
<?=$row['csnick'];?>
<?
}
?>
<br>
</td>
<td width="13" background="spacer.jpg" height="191"> </td>
</tr>
</table>
<table width="306" border="0" cellspacing="0" cellpadding="0">
<tr>
<td background="blabottom.jpg" height="8"></td>
</tr>
</table>
<br>
</td>
<td width="2" bgcolor="000000" height="356"></td>
</tr>
</table>
<table width="776" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="775" bgcolor="C44100" align="center"><font face="verdana" size="1"> © Clan Juveniles www.juveniles.tk </font></td>
<td width="2" bgcolor="000000"></td>
</tr>
</table>
<table width="776" height="2" bgcolor="000000" border="0" cellspacing="0" cellpadding="0">
<tr>
<td></td>
</tr>
</table>
</body>
</html>
