Hey jeg er ved og lave et Member script.. men kan ikke helt huske hvad man skal skrive for den henter info fra mysql..
Mit script:
<?
include ('admin/config.php');
$resultat = mysql_query("select * from users WHERE rank = 'CL'");
?>
<html>
<head>
<meta http-equiv="Content-Language" content="da">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>DKTeam1</title>
</head>
<body>
<table id="table16" style="BORDER-BOTTOM-COLOR: green; BORDER-TOP-STYLE: none; BORDER-TOP-COLOR: green; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none; BORDER-BOTTOM-STYLE: none; border-collapse:collapse" cellSpacing="0" borderColorDark="#666666" cellPadding="0" width="570" borderColorLight="#CCCCCC" border="1" fpstyle="1,001111100" bordercolor="#111111">
<tr>
<td style="BORDER-BOTTOM-COLOR: green; BORDER-TOP-STYLE: none; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none; BORDER-BOTTOM-STYLE: none" width="74%"> <table id="table17" style="BORDER-TOP: black 0.75pt solid; BORDER-LEFT: black 0.75pt solid; BORDER-BOTTOM: black 0.75pt solid; BORDER-RIGHT-STYLE: none" cellSpacing="0" borderColorDark="#666666" cellPadding="0" width="95%" borderColorLight="#cccccc" border="1" fpstyle="16,010101100">
<tr>
<td style="BORDER-RIGHT: black 0.75pt solid; FONT-WEIGHT: normal; BORDER-TOP-STYLE: none; BORDER-LEFT-STYLE: none; BORDER-BOTTOM-STYLE: none" width="96%">
<p align="left"><b>
<font face="Base 02"> <? echo $row2[navn]; ?></font></b></td>
</tr>
</table>
<table id="table18" style="BORDER-TOP: black 0.75pt solid; BORDER-LEFT: black 0.75pt solid; BORDER-BOTTOM: black 0.75pt solid; BORDER-RIGHT-STYLE: none" cellSpacing="0" borderColorDark="#666666" cellPadding="0" width="95%" borderColorLight="#cccccc" border="1" fpstyle="16,010101100" height="241">
<tr>
<td style="BORDER-RIGHT: black 0.75pt solid; FONT-WEIGHT: normal; BORDER-TOP-STYLE: none; BORDER-LEFT-STYLE: none; BORDER-BOTTOM-STYLE: none" align="left" width="50%" bgColor="#000000" height="11">
<span style="FONT-WEIGHT: 700; FONT-SIZE: 8pt">
<font face="Verdana" color="#FFFFFF"> Computer info</font></span></td>
<td style="BORDER-RIGHT: black 0.75pt solid; FONT-WEIGHT: normal; BORDER-TOP-STYLE: none; BORDER-LEFT-STYLE: none; BORDER-BOTTOM-STYLE: none" align="left" width="36%" bgColor="#000000" height="11">
<font face="Verdana" color="#FFFFFF">
<span style="FONT-WEIGHT: 700; FONT-SIZE: 8pt"> Personlig info</span></font></td>
<td style="BORDER-RIGHT: black 0.75pt solid; FONT-WEIGHT: normal; BORDER-TOP-STYLE: none; BORDER-LEFT-STYLE: none; BORDER-BOTTOM-STYLE: none" align="left" width="14%" bgColor="#000000" height="11">
<span style="font-weight: 700">
<font face="Verdana" style="font-size: 8pt" color="#FFFFFF">
Foto</font></span></td>
</tr>
<tr>
<td style="BORDER-RIGHT: black 0.75pt solid; BORDER-TOP: black 0.75pt solid; FONT-WEIGHT: normal; BORDER-LEFT-STYLE: none; BORDER-BOTTOM-STYLE: none" align="left" width="51%" height="122">
<b><font face="Verdana" style="font-size: 8pt"> </font></b><font face="Arial, Arial, Helvetica"><b><font style="FONT-SIZE: 8pt" face="Verdana">Mus:</font></b><font style="FONT-SIZE: 8pt" face="Verdana">
mus<b><br>
Ram: </b></font></font><font style="FONT-SIZE: 8pt" face="Verdana">
ram<b><br>
Monitor: </b>monitor<b> <br>
Headset: </b>heatset<b> <br>
Tastatur:</b> tastatur<b> <br>
Grafikkort: </b>grafik<b> <br>
Mussemåtte: </b>måtte </font></td>
<td style="BORDER-RIGHT: black 0.75pt solid; BORDER-TOP: black 0.75pt solid; FONT-WEIGHT: normal; BORDER-LEFT-STYLE: none; BORDER-BOTTOM-STYLE: none" align="left" width="38%" height="122">
<font style="FONT-SIZE: 8pt" face="Verdana"><b> Bor: </b>
bor<b><br>
Land: </b>land<b> <br>
Navn: </b>navn<b> <br>
Alder: </b>alder<b> <br>
Kontakt <br>
</b></font><span style="FONT-SIZE: 8pt"><font face="Verdana"><b>Msn: </b>
msn<b> <br>
</b>
</font></span>
<font style="font-size: 8pt" face="Verdana">
<b> E-mail: </b>mail </font>
<p><font style="FONT-SIZE: 8pt" face="Verdana"> </font></td>
<td style="BORDER-RIGHT: black 0.75pt solid; BORDER-TOP: black 0.75pt solid; FONT-WEIGHT: normal; BORDER-LEFT-STYLE: none; BORDER-BOTTOM-STYLE: none" align="left" width="14%" height="122">
<font face="Verdana">
<img border="0" src="images/nopic.gif" width="157" height="130"></font></td>
</tr>
<tr>
<td style="BORDER-RIGHT: black 0.75pt solid; BORDER-TOP: black 0.75pt solid; FONT-WEIGHT: normal; BORDER-LEFT-STYLE: none; BORDER-BOTTOM-STYLE: none" align="left" width="50%" bgColor="#000000" height="10">
<font face="Verdana" color="#FFFFFF"><span style="FONT-SIZE: 8pt"><b>
Personlig tekst</b></span></font></td>
<td style="BORDER-RIGHT: black 0.75pt solid; BORDER-TOP: black 0.75pt solid; FONT-WEIGHT: normal; BORDER-LEFT-STYLE: none; BORDER-BOTTOM-STYLE: none" align="left" width="50%" bgColor="#000000" height="10" colspan="2">
<font face="Verdana" color="#FFFFFF">
<span style="FONT-SIZE: 8pt"> <b>Counter-Strike info</b></span></font></td>
</tr>
<tr>
<td style="BORDER-RIGHT: black 0.75pt solid; BORDER-TOP: black 0.75pt solid; FONT-WEIGHT: normal; BORDER-LEFT-STYLE: none; BORDER-BOTTOM-STYLE: none" width="49%" height="90">
<font color="#FFFFFF" style="font-size: 8pt" face="Verdana"> <br>
<br>
<br>
<br>
<br>
</font></td>
<td style="BORDER-RIGHT: black 0.75pt solid; BORDER-TOP: black 0.75pt solid; FONT-WEIGHT: normal; BORDER-LEFT-STYLE: none; BORDER-BOTTOM-STYLE: none" width="49%" height="90" colspan="2">
<p align="left">
<font style="FONT-SIZE: 8pt" face="Verdana"><b> Nick: </b>
nick<b><br>
Sens: </b>sens <b><br>
Rang: </b>rang<b> </b><br>
<b>Status:</b>
</font>
<font style="font-size: 8pt; " face="Verdana">
Aktiv<b><br>
Fav. map: </b>map<b> <br>
Opløsning: </b>opløs<b> <br>
Fav. våben: </b>våben<b> </b></font></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
Og mit andet spørgsmål er .. hvordan får jeg den til og lave en ny tabel når der kommer nye members ?? for det kommer til og se fpr dumt ud hvis der tomme tabeler..
Hilsen Mike
Håber i har tid til og hjælpe.. 150point til den der kan hjælpe mig