php - Hvordan får jeg den til og hente info fra mysql - Udvikleren.dk

Tags: php

<< < 1 2 3 > >>

Bruger #9607 @ 11.03.06 13:37

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:

Kode

<?
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

24 svar postet i denne tråd vises herunder
1 indlæg har modtaget i alt 5 karma

Sorter efter stemmer Sorter efter dato

Bruger #9674 @ 16.03.06 07:57

111

Nu har jeg rettet den så den skulle komme til at passe...

Jeg har rykket dit while tag op over <table>, Og lukker den så i slutningen af </table>

Prrøv at tjekke om ikke dette hvirker...

Kode

<?
include ('admin/config.php');
$resultat = mysql_query("select * from users WHERE rang = '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>
<?php
while ($raekke = mysql_fetch_array($resultat)) {
   extract($raekke);
echo "
?>
<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"> <?
include ('admin/config.php');
$resultat = mysql_query("select * from users WHERE rang = 'CL'");


   echo "$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">
                <? echo "$mus"; ?><b><br>
				 Ram: </b></font></font><font style="FONT-SIZE: 8pt" face="Verdana">
                <? echo "$ram"; ?><b><br>
				 Monitor: </b><? echo "$monitor"; ?><b> <br>
				 Headset: </b><? echo "$headset"; ?><b> <br>
				 Tastatur:</b> <? echo "$tastatur"; ?><b> <br>
				 Grafikkort: </b><? echo "$grafik"; ?><b> <br>
				 Mussemåtte: </b><? echo "$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><? echo "$bor"; ?><b><br>
				 Land: </b><? echo "$land"; ?><b> <br>
				 Navn: </b><? echo "$navn"; ?><b> <br>
				 Alder: </b><? echo "$alder"; ?><b> <br>
				<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">
				<p align="center">
				<font color="#FFFFFF" style="font-size: 8pt" face="Verdana"> <br>
                 <br>
                </font>
				<font size="1" face="Verdana"><? echo "$tekst"; ?></font><font color="#FFFFFF" style="font-size: 8pt" face="Verdana"><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><? echo "$sens"; ?> <b><br>
				 Rang: </b><? echo "$rang"; ?><b> </b><br>
				 <b>Status:</b>
				</font>
				<font style="font-size: 8pt; " face="Verdana">
				Aktiv<b><br>
				 Fav. map: </b><? echo "$map"; ?><b> <br>
				 Opløsning: </b><? echo "$opløs"; ?><b> <br>
				 Fav. våben: </b><? echo "$våben"; ?><b> </b></font></td>
			</tr>
		</table>
		</td>
	</tr>
</table>
<?php
";
}
?>
</body>

</html>

Indlæg senest redigeret d. 16.03.2006 07:58 af Bruger #9674

Bruger #9607 @ 16.03.06 17:52

den siger "Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /hsphere/local/home/caspar88/web-csclan.dk/cl.php on line 21
"

Bruger #9607 @ 26.03.06 01:26

Plzz Help... har prøvet alt muligt.. men når jeg laver den ene fejl kommer der en ny

Bruger #9607 @ 26.03.06 22:26

nu jeg har prøvet det,,

og ja fejlen er væk.. men nu er siden bare helt hvid

der er en bruger i databasen..

scriptet:

Kode

<?
while ($raekke = mysql_fetch_array($resulatat)) {
   extract($raekke);
?>

<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"> <?
include ('admin/config.php');
$resultat = mysql_query("select * from users WHERE rang = 'CL'");


   echo "$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">
                <? echo "$mus"; ?><b><br>
				 Ram: </b></font></font><font style="FONT-SIZE: 8pt" face="Verdana">
                <? echo "$ram"; ?><b><br>
				 Monitor: </b><? echo "$monitor"; ?><b> <br>
				 Headset: </b><? echo "$headset"; ?><b> <br>
				 Tastatur:</b> <? echo "$tastatur"; ?><b> <br>
				 Grafikkort: </b><? echo "$grafik"; ?><b> <br>
				 Mussemåtte: </b><? echo "$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><? echo "$bor"; ?><b><br>
				 Land: </b><? echo "$land"; ?><b> <br>
				 Navn: </b><? echo "$navn"; ?><b> <br>
				 Alder: </b><? echo "$alder"; ?><b> <br>
				<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">
				<p align="center">
				<font color="#FFFFFF" style="font-size: 8pt" face="Verdana"> <br>
                 <br>
                </font>
				<font size="1" face="Verdana"><? echo "$tekst"; ?></font><font color="#FFFFFF" style="font-size: 8pt" face="Verdana"><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><? echo "$sens"; ?> <b><br>
				 Rang: </b><? echo "$rang"; ?><b> </b><br>
				 <b>Status:</b>
				</font>
				<font style="font-size: 8pt; " face="Verdana">
				Aktiv<b><br>
				 Fav. map: </b><? echo "$map"; ?><b> <br>
				 Opløsning: </b><? echo "$opløs"; ?><b> <br>
				 Fav. våben: </b><? echo "$våben"; ?><b> </b></font></td>
			</tr>
		</table>
		</td>
	</tr>
</table>
<?php
}
?>
</body>

</html>

Bruger #9674 @ 27.03.06 10:16

111

hmm... mærkeligt...

Har du tjekket om du kan få noget data ud af databasen bare med nogle simple test alla:

Kode

<?php
$sql = "SELECT * FROM users WHERE rank = 'cl'";
$raekke = mysql_query($sql);

echo "Dette er en lille database test:<br>Navn: $raekke[navn]";
?>

Hvis dette hvirker så skriv... så laver jeg lige dit script om igen så det hvirker...

Ellers så er det en fejl i din SQL query, ellers din database...

Tror umdiddel bart det er noget med databasen...

Bruger #9607 @ 27.03.06 15:30

hmm... mærkeligt...

Har du tjekket om du kan få noget data ud af databasen bare med nogle simple test alla:
Kode
<?php
$sql = "SELECT * FROM users WHERE rank = 'cl'";
$raekke = mysql_query($sql);

echo "Dette er en lille database test:<br>Navn: $raekke[navn]";
?>
Hvis dette hvirker så skriv... så laver jeg lige dit script om igen så det hvirker...

Ellers så er det en fejl i din SQL query, ellers din database...

Tror umdiddel bart det er noget med databasen...

Det der script henter heller ikke noget..

Men jeg har fået et script der godt kunne..

Kode

<?
include ('admin/config.php');
$resultat = mysql_query("select * from users");

while ($raekke = mysql_fetch_array($resultat)) {
   extract($raekke);
   echo "<b>Navn:</b> $navn <b>Point:</b> $rank<br />";
}

?>

www.Web-CsClan.dk/test.php <--- Det script der kan
www.Web-CsClan.dk/cl.php <---- Det script du lige har lagt ud
www.Web-CsClan.dk/crew.php <---- Det script som skal virke

Bruger #9674 @ 28.03.06 19:46

111

Hehe... kan godt se hvad problemet er... hehe...

Jeg havde lige glemt mysql_fetch_array()

Kode

<?php
$sql = "SELECT * FROM users WHERE rank = 'cl'";
$sql1 = mysql_query($sql);
$raekke = mysql_fetch_array($sql1);

echo "Dette er en lille database test:<br>Navn: $raekke[navn]";
?>

Skal jeg lave din kode helt om eller?

Forstod ikke lige om du havde fået det til at hvirke... hehe...

Bruger #9607 @ 28.03.06 22:41

Hehe... kan godt se hvad problemet er... hehe...

Jeg havde lige glemt mysql_fetch_array()

Kode
<?php
$sql = "SELECT * FROM users WHERE rank = 'cl'";
$sql1 = mysql_query($sql);
$raekke = mysql_fetch_array($sql1);

echo "Dette er en lille database test:<br>Navn: $raekke[navn]";
?>
Skal jeg lave din kode helt om eller?

Forstod ikke lige om du havde fået det til at hvirke... hehe...

Må du godt gøre

for er helt lost efter hånden..

Bruger #9674 @ 29.03.06 18:45

111

Ok... det tager lidt tid... men skal nok poste det så snart det er færdigt...

Bruger #9674 @ 29.03.06 18:58

111

Kode

<?
include ('admin/config.php');
$resultat = mysql_query("select * from users WHERE rang = '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>
		<?php
			while($raekke = mysql_fetch_array($resultat)) {
				extract($raekke);
		?>		
			<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">
						<? echo "$mus"; ?><b><br>
						 Ram: </b></font></font><font style="FONT-SIZE: 8pt" face="Verdana">
						<? echo "$ram"; ?><b><br>
						 Monitor: </b><? echo "$monitor"; ?><b> <br>
						 Headset: </b><? echo "$headset"; ?><b> <br>
						 Tastatur:</b> <? echo "$tastatur"; ?><b> <br>
						 Grafikkort: </b><? echo "$grafik"; ?><b> <br>
						 Mussemåtte: </b><? echo "$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><? echo "$bor"; ?><b><br>
						 Land: </b><? echo "$land"; ?><b> <br>
						 Navn: </b><? echo "$navn"; ?><b> <br>
						 Alder: </b><? echo "$alder"; ?><b> <br>
						<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">
						<p align="center">
						<font color="#FFFFFF" style="font-size: 8pt" face="Verdana"> <br>
						 <br>
						</font>
						<font size="1" face="Verdana"><? echo "$tekst"; ?></font><font color="#FFFFFF" style="font-size: 8pt" face="Verdana"><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><? echo "$sens"; ?> <b><br>
						 Rang: </b><? echo "$rang"; ?><b> </b><br>
						 <b>Status:</b>
						</font>
						<font style="font-size: 8pt; " face="Verdana">
						Aktiv<b><br>
						 Fav. map: </b><? echo "$map"; ?><b> <br>
						 Opløsning: </b><? echo "$opløs"; ?><b> <br>
						 Fav. våben: </b><? echo "$våben"; ?><b> </b></font></td>
					</tr>
				</table>
				</td>
			</tr>
		</table>
		<?php
			}
		?>
	</body>

</html>

Sådan... hehe tog ikke så lang tid...

Jeg ved ikke om det hvirker men det skulle jeg mene...

Du skal nok lige oprette forbindelse til din database o.s.v. men det skulle også være det...

Og så lige et lille tip... Lær noget CSS... hehe, meget ireterende at se så meget style="" i hver table... det vil gøre det meget mere enkelt at se på...

Men skriv lige igen hvis det ikke hvirker...

<< < 1 2 3 > >>

Hvordan får jeg den til og hente info fra mysql

Karma barometer (30 dage)

Modtaget

Givet

Favorit hos
Forum tråde
Artikler