Is this possible?

[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

[ace21]

What are the new values $in and $out that you introduce in the second query?

[Anon]

i think NULL create an error try to use a blank '' instead of the null... perhabs it would help if u tell us what field are in the table u want to write...

[Anon]

No, the null is not a problem because the first script is working fine.(The fields in the database reflect the number of variables in the php-code and the null is an autoincrement value in the database.)
The Problem is that I can't get the same variables filled with a value several times out of one HTML form. This is the complete code for the multiple passing of the values. In the preceding HTML form '$in' and 'out' are values that have to be filled in. So I thought I made their appearance a condition in order to avoid empty datasets in the database. Here is the complete code of the put_db file:

<?php
//putbank.php
include "common.inc";

$link_id = db_connect ();

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

if (!$query)
{
echo 'Entry was not successful. Please call 094 or mail to [e-mail]';
}
else
{
echo 'Entry was successful. Thank you!';
}
$result = mysql_query ($query);
?>

[Anon]

Heureka!!
I solved it myself. I just gave the variables in the form different names for each dataset and repeatet the query for each set in the php-putter (Is there maybe a more elegant solution? Maybe I could increment the variables by an Index in a do while loop automaticaly?):

<?php
//putbank.php
include "common.inc";

$link_id = db_connect ();

$query = "INSERT INTO bank VALUES (NULL, '$date','$cheq' ,'$supplier' ,'$purchaser' , '$int_invoice_no', '$invoice_no',
'$in', '$out', '$description')";
echo "<table border=10>
<tr><td>$date</td>
<td>$cheq</td>
<td>$supplier</td>
<td>$purchaser</td>
<td>$int_invoice_no</td>
<td>$invoice_no</td>
<td>$in</td>
<td>$out</td>
<td>$description</td>
</table>";

if (!$query)
{
echo 'Entry was not successful. Please call 094 or 094 or mail to [e-mail]';
}
else
{
echo 'Entry was successful. Thank you!';
}
$result = mysql_query ($query);

$query = "INSERT INTO bank VALUES (NULL, '$date1','$cheq1' ,'$supplier1' ,'$purchaser1' , '$int_invoice_no1', '$invoice_no1',
'$in1', '$out1', '$description1')";
echo "<table border=10>
<tr><td>$date1</td>
<td>$cheq1</td>
<td>$supplier1</td>
<td>$purchaser1</td>
<td>$int_invoice_no1</td>
<td>$invoice_no1</td>
<td>$in1</td>
<td>$out1</td>
<td>$description1</td>
</table>";

if (!$query)
{
echo 'Entry was not successful. Please call 0949 or 094 or mail to [e-mail]';
}
else
{
echo 'Entry was successful. Thank you!';
}
$result = mysql_query ($query);

?>