I have been over the code all day now and can simply not see why it is not inserting.
any ideas ?
form.php
<form method="post" action="insert.php">
Name Of Band:</br>
<input type="text" name="Name" /><br />
Show Name:</br>
<input type="text" name="show" /><br />
Venue:</br>
<input type="text" name="Venue" /><br />
Category:</br>
<input type="text" name="Category" /><br />
Stock:</br>
<input type="text" name="Stock" /><br />
Time And Date:</br>
<input type="datetime-local" name="time" /><br />
Price:</br>
<input type="text" name="price" /><br />
Infomation:</br>
<textarea cols="50" rows="4" name="infomation" /></textarea></br>
<input type="submit" value="Add Band"/>
</form>
insert.php
require 'core/init.php';
$Name = $_REQUEST["Name"];
$show = $_REQUEST["show"];
$Venue = $_REQUEST["Venue"];
$Category = $_REQUEST["Category"];
$Stock = $_REQUEST["Stock"];
$time = $_REQUEST["time"];
$price = $_REQUEST["price"];
$infomation = $_REQUEST["infomation"];
$query = "INSERT INTO bands (Name, show, Venue, Category, Stock, time, price, infomation)
VALUES ('$Name', '$show', '$Venue', '$Category', '$Stock', '$time', '$price', '$infomation')";
mysql_query ($query, $linkme)
header("location:admin.php");
Table
CREATE TABLE IF NOT EXISTS `bands` (
`Band_id` int(11) NOT NULL AUTO_INCREMENT,
`Name` varchar(20) NOT NULL,
`show` varchar(22) NOT NULL,
`Venue` varchar(20) NOT NULL,
`Category` varchar(20) NOT NULL,
`time` datetime NOT NULL,
`price` float NOT NULL,
`Stock` int(11) NOT NULL,
`infomation` text NOT NULL,
PRIMARY KEY (`Band_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;