hmmm okay didn't know that. Da jeg er ny i php er der måske en smarter måde at lave det på men anyway here goes:
"index.php":
<?php
mysql_connect("server","username","password");
mysql_select_db("database");
$foresp = mysql_query("SELECT * FROM klan order by id");
?>
<table width="400">
<tr>
<TD>Klan:</td>
<td>Type:</td>
<td>Score:</td>
<td>Mere info:</td>
</tr>
<?php
while($row = mysql_fetch_array($foresp)){
$id = $row["id"];
$clan = $row["clan"];
$type = $row["type"];
$score = $row["score"];
$report = $row["repost"];
echo"<tr><td>$clan</td>
<td>$type</td>
<td>$score</td>
<td><a href='mereinfo.php?match=$id'>Tryk For info</a></td></tr>";
}
?>
</table>
**********************************
"mereinfo.php":
<?php
$match = $_GET["match"];
mysql_connect("server","username","password");
mysql_select_db("database");
$foresp2 = mysql_query("SELECT * FROM klan where id ='$match'");
?>
<table border="1" width="400">
<?php
while($row = mysql_fetch_array($foresp2)){
$id = $row["id"];
$clan = $row["clan"];
$type = $row["type"];
$score = $row["score"];
$report = $row["report"];
echo"<td>$clan</td>
<td>$type</td>
<td>$score</td>
<td>$report</td>";
}
?>
</tr>
</table>
**********************************
"indsaet.php"
<?php
$input = &$HTTP_POST_VARS['indsæt'];
$clan = &$HTTP_POST_VARS['clan'];
$type = &$HTTP_POST_VARS['type'];
$score = &$HTTP_POST_VARS['score'];
$report = &$HTTP_POST_VARS['report'];
if(empty($input)){
echo "
<body>
<form action='indsaet.php?indsaet=ja' method='post'>
Clan<input type='text' name='clan'><br>
Type<input type='text' name='type'><br>
Score<input type='text' name='score'><br>
Report<textarea name='report'></textarea>
<input type='submit' name='indsæt' value='indsæt'>
</form>
</body>
</html>
";}
else {
mysql_connect("server","username","password");
mysql_select_db("database");
mysql_query("INSERT INTO klan (clan, type, score, report) values ('$clan', '$type', '$score', '$report')");
echo "Sucessded";
}
?>
- SpeC - #SpeC.DK @ Q-NET