My creation code is as follows:
Code: Select all
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("test_db", $con);
$sql = "CREATE TABLE articleData
(
article_id INT( 4 ) NOT NULL AUTO_INCREMENT,
articleTitle varchar(255),
articleDate varchar(255),
articleAuthor varchar(255),
articleSource varchar(255),
articleSubTitle varchar(255),
articleTeaser varchar(255),
articleContent longtext,
UNIQUE ( article_id )
)";
mysql_query($sql,$con);
mysql_close($con);
?>Code: Select all
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("test_db", $con);
$sql="INSERT INTO articleData (article_ID, articleTitle, articleSubtitle, articleAuthor, articleDate, articleSource, articleTeaser, articleContent)
VALUES
(NULL,'$_POST[articletitle]','$_POST[articlesubtitle]','$_POST[articleauthor]','$_POST[articledate]','$_POST[articlesource]','$_POST[articleteaser]','$_POST[articlecontent]')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
$URL="http://localhost/hr-bin/controlpanel/articles.php";
header ("Location: $URL");
mysql_close($con)
?>Whenever I simply view all of the rows, every column is filled in except the article_ID column (which remains blank).
Does anyone have any ideas as to what could be wrong with my code?