I'm probably missing something really simple here, but I've been looking at this code forever and can't see what is wrong.
It's a simple submit form. It worked fine before I added a few extra fields, but now it runs correctly and appears to work but doesn't add anything to the database.
Can anyone help me out?
Thanks
<?php
session_start();
if (!$_SESSION["valid_user"])
{
// User not logged in, redirect to login page
Header("Location: login.php");
}
include ("dbConfig.php");
?>
<?php virtual('menu.php'); ?>
<br><br>
<SCRIPT LANGUAGE="JavaScript">
function all_os() {
document.inputform.pro.checked=true;
document.inputform.home.checked=true;
document.inputform.wintt.checked=true;
document.inputform.winme.checked=true;
document.inputform.winne.checked=true;
document.inputform.winnf.checked=true;
document.inputform.winnt.checked=true;
}
function all_os2() {
document.inputform.pro.checked=false;
document.inputform.home.checked=false;
document.inputform.wintt.checked=false;
document.inputform.winme.checked=false;
document.inputform.winne.checked=false;
document.inputform.winnf.checked=false;
document.inputform.winnt.checked=false;
}
</SCRIPT>
<?php
if ($submit) {
$sql = "INSERT INTO solutions (user_id,title,text,date,pro,home,wintt,winme,winne,winnf,winnt,app,app_version) VALUES ('$user_id','$title','$text','$date','$xp_pro','$xp_home','$2000','$me','$98','$95','$nt','$app','$app_version')";
$result = mysql_query($sql);
echo "Thank you! Your message has been posted.\n";
} else{
?>
<form method="post" name="inputform" action="<?php echo $PHP_SELF?>">
<input type="hidden" name="date" value="<?php echo date("d.m.y, H:i:s",time()); ?>">
<input type="hidden" name="user_id" value="<?php print $_SESSION["valid_id"]; ?>">
My problem concerns: <select size="1" name="category">
<option value="1" selected>General Problem</option>
<option value="2">Email</option>
<option value="3">Internet</option>
<option value="4">Networking</option>
<option value="5">Printing</option>
</select><br><br>
Which operating system(s) does this solution apply to?:<br><br>
<input type="checkbox" value="1" name="pro" value="ON"> Win XP Pro
<input type="checkbox" value="1" name="home" value="ON"> Win XP Home
<input type="checkbox" value="1" name="wintt" value="ON"> Win 2000 <br>
<input type="checkbox" value="1" name="winnt" value="ON"> Win NT
<input type="checkbox" value="1" name="winme" value="ON"> Win ME
<input type="checkbox" value="1" name="winne" value="ON"> Win '98
<input type="checkbox" value="1" name="winnf" value="ON"> Win '95
<br><a href="javascript:all_os()">Select all</a> <a href="javascript:all_os2()">Clear</a>
<br><br>
Which Application does this solution apply to?:<br><br>
<select size="1" name="app">
<option value="1" selected>None</option>
<option value="2">Internet Explorer</option>
<option value="3">Word</option>
<option value="4">Excel</option>
<option value="5">Powerpoint</option>
<option value="6">Access</option>
<option value="7">Outlook</option>
<option value="8">Outlook Express</option>
<option value="9">Windows Messenger</option>
<option value="10">Other</option>
</select>
Version: <input type="Text" size="4" name="app_version"><br><br><br>
Problem Title: <input type="Text" size="37" name="title">
<br><br>Problem Detail:<br> <textarea rows="10" name="text" cols="40"></textarea><br><br>
<input type="Submit" name="submit" value="Send Message">
</form>
<?php
} // end if
?>
