Hjælp til en liga tabel
Hej alle....Jeg sider med en liga table, i denne er der
Hold , V, U, T, +, -, point
Jeg vil så gerne have at jeg kan hive alt ud fra min MySql og rette i den, og gemme det igen
Dette er min ( Sql table )
CREATE TABLE Stillingen (
Id int(4) unsigned zerofill NOT NULL auto_increment,
Hold varchar(50) NOT NULL UNIQUE default '',
kampe varchar(50) NOT NULL default '',
Vondet varchar(50) NOT NULL default '',
Uafgjort varchar(70) NOT NULL default '',
Tabt varchar(70) NOT NULL default '',
plus varchar(15) NOT NULL default '',
minus varchar(15) NOT NULL default '',
point varchar(30) NOT NULL default '',
forimod varchar(30) NOT NULL default '',
PRIMARY KEY (id)
)
Dette er selve koden der kommer ud på php siden
Stillingen.php
<?php
include("include/kontakt_Db.php");
?>
<Center>
<table width="400" height="5%" valign="top" cellpadding="2" cellspacing="0" border="0"><tr>
<td bgcolor="#ffffff" valign="top"><b>Hold</b></td>
<td bgcolor="#ffffff" valign="top"><Center><b>K</b></Center></td>
<td bgcolor="#ffffff" valign="top"><Center><b>V</b></Center></td>
<td bgcolor="#ffffff" valign="top"><Center><b>U</b></Center></td>
<td bgcolor="#ffffff" valign="top"><Center><b>T</b></Center></td>
<td bgcolor="#ffffff" valign="top"><Center><b>+</b></Center></td>
<td bgcolor="#ffffff" valign="top"><Center><b>-</b></Center></td>
<td bgcolor="#ffffff" valign="top"><Center><b>P</b></Center></td>
<?php
$query = mysql_query("select * FROM Stillingen order by point desc");
while ($row = mysql_fetch_array($query)) {
echo "<tr>";
echo "<td bgcolor=\"#ffffff\">$row[Hold]</td>";
echo "<td bgcolor=\"#ffffff\"><Center>$row[kampe]</Center></td>";
echo "<td bgcolor=\"#ffffff\"><Center>$row[Vondet]</Center></td>";
echo "<td bgcolor=\"#ffffff\"><Center>$row[Uafgjort]</Center></td>";
echo "<td bgcolor=\"#ffffff\"><Center>$row[Tabt]</Center></td>";
echo "<td bgcolor=\"#ffffff\"><Center>$row[plus]</Center></td>";
echo "<td bgcolor=\"#ffffff\"><Center>$row[minus]</Center></td>";
echo "<td bgcolor=\"#ffffff\"><Center>$row[point]</Center></td>";
echo "</tr>";
}
?>
</table></Center>
<?php
mysql_close($conn);
?></font></b>
