Stock Recording System - I basically wants to see the data recorded in the table sql. yet this is not the case.
mysql_query("INSERT INTO Produk FROM stock VALUES ('Produk')");
mysql_query("INSERT INTO Jumlah FROM stock VALUES ('Jumlah')");
mysql_query("INSERT INTO Tanggal_Masuk FROM stock VALUES ('Tanggal_Masuk')");
Is that instruction not enough to record data? Thanks.
... It's good practice to do so as reserved words can often mess up your queries. Anyway - backticks around fieldnames, single quotes around values (if in a double quoted string and data is not numeric). Tony's sql should work.
I just revisited your code, several points to check on. The <form> has action="print.php" , so it's sending post data elsewhere. The mysql query is within the <form> tags. If you are 'POST'ing your form you need to create the variables to put into mysql i.e. $PO=$_POST['batch']; $tanggal=$_POST['Tanggal']; etc; And your <select> element has the onClick method so it's gonna submit the form as soon as it's changed.
I don't wish to seem rude or unhelpful, but we have given you a lot of help on this one already. Download the manual that Pritaeas pointed you to and also the php manual is downloadable, by using those carefully you should be able to work this out for yourself. Nobody is going to write the code for you.