I am writing a basic script which allows users to submit tutorials to a mysql database but Im having some trouble with it but its really weird...

Heres what Ive got:

PHP Code:

$category = $_POST['category'];
$title = $_POST['title'];
$caption = $_POST['caption'];
$content = $_POST['content'];
$author = $_POST['author'];
$email = $_POST['email'];


echo "$_POST['title']";
$query = "INSERT INTO `article_art` ( `id` , `category` , `active` , `name` , `caption` , `content` , `author`) VALUES ('', '$category', '$active', '$title', '$caption', '$content', '$author');";
mysql_query($query) or die ("dead"); 


This is submitted to via a HTML form where all the input boxes have been named as category, title, caption, content, author and email.

The problem is that when the form is submitted the variables are not available in the script therefore it doesnt add into the database properly.

Now the strange thing is that I have created this script locally on my computer and it worked fine but when i now tried it live it doesnt want to work.

I just cant figure it out... Is there something Im doing wrong?

Thanks

Please post the form code as well. It's handy to see how the vars are being posted to the sql action. Also, upload a script to your local and live servers that does a phpinfo. Run the phpinfo scripts and compare the settings for both environments. Your answer could very well be revealed by the different php ini settings.

On the ..or die(" part of the query, change it to

PHP Code:

or die("Could not complete query because ."mysql_error()); 


try doing this

PHP Code:


 $category = trim($_POST['category']); 


trim -- Strip whitespace (or other characters) from the beginning and end of a string

ok no worries - problem solved

thanks anyway