mysql_query("INSERT INTO warehouse (pname,desc,costmedia,rrp,sname,snumber,saddress,quantity,notes) VALUES ('".$_POST['pname']."','".$_POST['desc']."','".$_POST['costmedia']."','".$_POST['rrp']."','".$_POST['sname']."','".$_POST['snumber']."','".$_POST['saddress']."','".$_POST['quantity']."','".$_POST['notes']."')");
I have the above mysql query, but no data is getting entered into the database, however if I run this query:
mysql_query("INSERT INTO warehouse (pname) VALUES ('".$_POST['pname']."')");
that small bit of data gets entered, what's wrong with the long query? I am clueless, I have done inserts before with the above code and it has worked so I'm a bit confused
