Andet dum fejl..
Hmm, det er sikkert bare mig, men hvorfor viser den ikke noget ved dette:sql filen:
CREATE TABLE `live` (
`id` int(11) NOT NULL auto_increment,
`sted` varchar(100) NOT NULL default '',
`by` varchar(100) NOT NULL default '',
`entre` varchar(100) NOT NULL default '',
`fadb` varchar(100) NOT NULL default '',
`andet` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
"input" filen:(skrivlive.php)
<?php
session_start();
if (isset($_SESSION['aid'])) {
include("config.php");
if($_POST['send']){
mysql_query("INSERT INTO live (sted, by, entre, fadb, andet) values ('$_POST[sted]', '$_POST[by]', '$_POST[entre]', '$_POST[fadb]', '$_POST[andet]')");
header("Location: live.php");
}
?>
<html>
<head>
<title>Skriv Live</title>
</head>
<body>
<form action="live.php" method="POST">
Sted:<br>
<input name="sted" type="text" id="sted"><br>
By:<br>
<input name="by" type="text" id="by"><br>
Entré:<br>
<input name="entre" type="text" id="entre"><br>
Fadbamser:<br>
<input name="fadb" type="text" id="fadb"><br>
Andet:<br>
<textarea rows="3" name="andet" cols="20"></textarea><br>
<input name="send" type="submit" value="Send"></form>
</body>
</html>
<?php
}
?>
Siden hvor det BURDE vises på:(live.php)
<?
include("config.php");
$query = mysql_query("SELECT sted, by, entre, fadb, andet FROM live");
while ($row = mysql_fetch_array($query)) {
echo "<p><b>$row[sted]</b><br>";
echo "By - Sted - Adresse: $row[by]<br>";
echo "Entré: $row[entre]<br>";
echo "Fadbamser: $row[fadb]<br>";
echo "Andet:<br> $row[andet]";
echo "<font size='1' face='Arial'>";
echo "</font></p>";
echo "<br><br>";
}
?>
