Lægger det ikke ind i db
Er der ikke en der kan fortælle mig hvorfor den ikke gider indsætte en dvdfilm på listen. Den smider det ikke ind i dbKODE:
<?
/*--------------------------------------------------+
| PHP-Fusion 5.01 - Udlåns liste |
|----------------------------------------------------
| author: Palle Binderkrantz © 2002-2005 |
| web: http://www.DVDdatabasen.dk |
| email: Megacovers@Gmail.com.uk |
|---------------------------------------------|
| Released under the terms and conditions of |
| the GNU General Public License (Version 2) |
+--------------------------------------------*/
setlocale(LC_ALL, "da_DK");
if ($_POST[submit]) {
include ('../fusion_config.php');
$db = mysql_select_db("dvddata_dvddatabasen");
$sql = "INSERT INTO dvdudlaan (user_id, filmnr, wdato) VALUES ('$_POST user_id]', $_POST[filmnr], now())";
}
if ($_POST[slet]) {
include ('../fusion_config.php');
$sql = "DELETE FROM dvdudlaan WHERE filmnr = $_POST[filmnr]";
mysql_query($sql) or die(mysql_error());
}
?>
<html>
<head>
</head>
<body>
<center>
<p><b>Indsæt ny dvdfilm til udlån:</b></p>
<form action="viewpage.php?page_id=6" method="post">
<table>
<tr> <td> Brugernavn: </td> <td> <select name="user_id">
<?
$sql = "SELECT user_id, user_name FROM fusion_users WHERE user_groups LIKE '%1%' ORDER BY user_name ASC";
$query = mysql_query($sql);
while($data = mysql_fetch_array($query)) {
print "<option value=\"$data[user_id]\">$data[user_name]</option>\n";
}
?>
</select> </td> </tr>
<tr> <td> Filmnavn: </td> <td> <select name="filmnr">
<?
$sql = "SELECT dvdinfos_id, dvdinfos_name FROM fusion_dvdinfos ORDER BY dvdinfos_name ASC";
$query = mysql_query($sql);
while($data = mysql_fetch_array($query)) {
print "<option value=\"$data[dvdinfos_id]\">$data[dvdinfos_name]</option>\n";
}
?> </select>
</td> </tr>
<tr> </tr>
<tr> <td colspan="2"> <input type="submit" name="submit" class="button" value="Indsæt filmen!"> </td> </tr>
</table>
</form>
<br> </center>
<hr>
<b>Udlånte film:<b>
<?
include ("../fusion_config.php");
$sql = "SELECT UNIX_TIMESTAMP(du.wdato) AS wdato, du.filmnr, u.user_name, dvd.dvdinfos_name FROM dvdudlaan AS du, fusion_users AS u, fusion_dvdinfos AS dvd WHERE du.user_id = u.user_id AND dvd.dvdinfos_id = du.filmnr ORDER BY u.user_name ASC";
$query = mysql_query($sql);
while($data = mysql_fetch_array($query)) {
print "<p><form action=\"viewpage.php?page_id=6\" method=\"post\">";
print "<b><input type=\"hidden\" name=\"filmnr\" value=\"$data[filmnr]\"<b>";
print "<center><table cellpadding=0 cellspacing=0 border=0 width=100%>";
print "<td width=3%><font color=#0066CC><b>$data[filmnr]</b></font></td>";
print "<b><td width=28%><font color=#0066CC>$data[dvdinfos_name]</font></td>";
print "<td width=8%><font color=#0066CC>$data[user_name]</font></td>";
//print "<td width=15% ><font color=#0066CC>$data[wdato]</font></td>";
print "<td width=15% ><font color=#0066CC>" . date("d-m-Y",$data[wdato]) . "</font></td>";
print "<td width=2% align=right><input type=\"submit\" name=\"slet\" value=\"Slet\" class=\"button\"></td></form></table></p></center>";
}
?>
