first of all, i will say that i am relatively new to mysql.

here is the code i am using:

mysql_query("INSERT INTO jobs 
(date, time, status, category, subcategory, short_description, description, urgency, assigned_to, priority, dollar_rate) 
VALUES
('$date', '$time', '$status', '$category', '$subcategory', '$short_description', '$description', '$urgency', '$assigned_to', '$priority', '$dollar_rate')") 
or die(mysql_error());  

echo "data entered!";

It seems to be entering the data into the table twice, but only about half of the fields, the rest are left blank. Does anybody know what could be causing this?

validate the submitted data BEFORE sending the query.

http://www.webmaster-talk.com/php-fo...g-to-self.html