HTML forms and MySQL

[Anon]

Hello there and Happy New Year!

I'm trying to write some code in PHP that should put several sets of data from one HTML form into a MySQL database. It works pefectly fine when I do it with one set but I do not know how to do it with multiple ones. My code for the single set entry:

$query = "INSERT INTO bank VALUES (NULL, '$date','$cheq' ,'$supplier' ,'$purchaser' , '$int_invoice_no', '$invoice_no')";

And my unsuccessful one on the multiple sets:

while ($in>0 OR $out>0)
{
$query = "INSERT INTO bank VALUES (NULL, '$date','$cheq' ,'$supplier' ,'$purchaser' , '$int_invoice_no', '$invoice_no', '$in', '$out')";

}

If anybody ever had this kind of problem bevore please help me out!
Regards,
Frank

[Anon]

There's something missing from your while loop. I don't see how it is stepping from one set of data to the next.

Think about it this way . . . how does the while loop know when to stop looping? (answer: when the condition is false) How does the condition become false?

I don't think I did a very good job of explaining, but maybe you'll be able to follow it anyway.