Simple mysql insert not working

[dkin]

This is my code, it is very basic and was working before I altered it now I cant find the problem, I have hit all the usaual suspects and am finding nothing.

Please help.

function gameform()
{

$today = date("F j, Y");

echo '<form action="addcon.php?op=gameinsert" method="post" enctype="multipart/form-data">'
. 'Title: <input type="text" name="title" /><br />'
. 'Description: <textarea rows="30" cols="100" name="content"></textarea><br>'
. 'Genre: <select name="genre"><option value="1st Person Shooter">1st Person Shooter</option><option value="Action">Action</option><option value="Action/Adventure">Action/Adventure</option><option value="Classic Games">Classic Games</option><option value="Collections">Collections</option><option value="Fighting">Fighting</option><option value="Kids & Family Games">Kids & Family Games</option><option value="Online">Online</option><option value="Racing & Flying">Racing & Flying</option><option value="Role-Playing">Role-Playing</option><option value="Simulation">Simulation</option><option value="Sports & Outdoors">Sports & Outdoors</option><option value="Strategy">Strategy</option></select><br>'
. 'Publisher: <input type="text" name="publisher" /><br>'
. 'Developer: <input type="text" name="developer" /><br>'
. 'ESRB Rating: <select name="esrb"><option value="EC (Early Childhood)">EC (Early Childhood)</option><option value="E (Everyone)">E (Everyone)</option><option value="E10+ (Everyone 10 and older)">E10+ (Everyone 10 and older)</option><option value="T (Teen)">T (Teen)</option><option value="M (Mature)">M (Mature)</option><option value="AO (Adults Only)">AO (Adults Only)</option><option value="RP (Rating Pending)">RP (Rating Pending)</option></select><br>'
. 'Date: <input type="text" name="date" value="'.$today.' est"/><br>'
. 'Type (or select) Filename: <input type="file" name="uploadFile"><br>'
. '<input type="hidden" name="MAX_FILE_SIZE" value="250000" />'
. '<input type="submit" value="Add Game"/>'
. '</form>';
}

function gamein()
{
global $link, $title, $content, $genre, $publisher, $developer, $esrb, $date, $uploadFile;

$uploaddir = '/home/lordsoft/public_html/gs/images/games/';
$uploadfile = $uploaddir . basename($_FILES['uploadFile']['name']);

echo '<pre>';
if (move_uploaded_file($_FILES['uploadFile']['tmp_name'], $uploadfile)) {
echo "File is valid, and was successfully uploaded.\n";
} else {
echo "Possible file upload attack!\n";
}

echo 'Here is some more debugging info:';
print_r($_FILES);

print "</pre>";

$image = $_FILES['uploadFile']['name'];

echo $title.'<br>'.$content.'<br>'.$genre.'<br>'.$publisher.'<br>'.$developer.'<br>'.$esrb.'<br>'.$date;

$gresult = mysql_query("INSERT INTO games (title, desc, image, platform, publisher, developer, genre, esrb, date) VALUES ('$title', '$content', '$image', 'Xbox', '$publisher', '$developer', '$genre', '$esrb', '$date')", $link);

$gresult = mysql_query("INSERT INTO games (title, desc, image, platform, publisher, developer, genre, esrb, date) VALUES ('$title', '$content', '$image', 'Xbox', '$publisher', '$developer', '$genre', '$esrb', '$date')", $link);

if (isset($gresult))
{
echo '<center>Game Inserted</center>';
}
else
{
echo '<center>Insert Failed please go back and reinsert the game</center>';
}
gameform();
}

[arran]

dkin,

Probably due to 'desc' being a reserved word. Try quoting it:

INSERT INTO games (title, `desc`, image, platform, publisher, developer, genre, esrb, date) VALUES ('$title', '$content', '$image', 'Xbox', '$publisher', '$developer', '$genre', '$esrb', '$date')

arran.

[dkin]

you are now officially my hero :).

Thank you, now I can get some darn work done lol.

[mcibor]

Date is also reserved word, however for now mysql allows it. I would not only quote it, but would avoid using those words.

See the list [dev.mysql.com] provided by mysql

Michal Cibor