Form processing into another table

phplearner

This is the closest Subject title I could think of.

Here's the situation.

I managed to pull from a MySQL Table to display several columns along with a checkbox to select items (in this case, it will be cities with tax rates to end up writing/inputing the selected data into another MySQL Table (the initial page is like a Master "config").

Then later, to be able to pull the selected/written data from into a drop-down list (on a totally separate page) for the final choice to calculate from.

I'm now stuck and would appreciate any help to finish.

Omitting the db/pwd stuff, et.al, here's what is displaying OK at present for the 1st page:

mysql_select_db($database, $dbcnx);
$query = "SELECT cityname, taxrate FROM stw_city";
$list = mysql_query($query, $dbcnx) or die(mysql_error());
$row = mysql_fetch_assoc($list);

$cityname = " ";
$taxrate = " ";
?>

.. snipped some html

<TABLE width="200" BORDER="0" cellpadding="2" cellspacing="2">
<TR bgcolor="#c1c1c1">
<TD width="10" align="center"><B>Tax</B></TD>
<TD width="20" align="center"><B>Select</B></TD>
<TD align="center"><B>City</B></TD>
</TR>
<?php do { ?>
<TR bgcolor="#f2f2f2"> 
<TD width="10" align="right"><?php echo $row['taxrate'];?>
</TD>
<TD align="center"><?php echo '<input name="taxoption" type="checkbox" value="citynameplustaxrate">';?></TD>
<TD align="left"><?php echo $row['cityname']; ?></TD> 
</TR>
<?php } while ($row = mysql_fetch_assoc($list));?>
</TABLE>

I would like to have an alternating row color of #d8d8d8 with the current #f2f2f2 but can't figure it out.
In the checkbox value="citynameplustaxrate", I can't figure out how to substitute the $row['cityname'] and $row['taxrate'], or even if these can be combined. I must be able to put the cities AND corresponding tax rates into the 2nd table (separate columns), for ultimate selection and calculation purposes.
There may be 300 possible selections on the initial "Master config" page, but most likely no more than 15 or 20 selected before the Form is 'processed'. Here is the 2nd table structure:

CREATE TABLE stw_taxoptions (
ID int not null auto_increment primary key,
taxname varchar(45),
taxrate FLOAT(7) not null
);

Not sure how to code the Form tags (omitted) on the initial page and the final display page. I'm sure there is some kind of 'trick' to creating a drop-down list from table data on the 2nd page.

I'm also using align="right" for the 'taxrate" data, but it will NOT right-align!!!

Thanks for any help.

bad76

Wow, it's your christmas list? 😃

Ok, one at time:

1. I would like to have an alternating row color of #d8d8d8 with the current #f2f2f2 but can't figure it out.

you need a flipflop. Make a style you call .col0 and .col1
<stilye>
.col0{background-color:#d8d8d8}
.col1{background-color:#f2f2f2}
</style>

then just do instead of <TR bgcolor="#f2f2f2">
<TR CLASS="col<?= ($i&1)?>">
and insert $i++ in your while.

This give you 0 if $i is pair, else 1. Like a flipflop.

2. In the checkbox value="citynameplustaxrate", I can't figure out how to substitute the $row['cityname'] and $row['taxrate'], or even if these can be combined.

I don't understand so well, but you can add any hidden field:

When submit this will give you three array, with isset(taxoption[$n]) if checked, not set else.

3. Not sure how to code the Form tags (omitted) on the initial page and the final display page. I'm sure there is some kind of 'trick' to creating a drop-down list from table data on the 2nd page.

Try again, this is a bit obscure. May be 'trick' is called <select> tag....

For right alignement try to give as width more than 10...

phplearner

bad76:

Thanks again. I just got this working for the 2nd page:

mysql_select_db($database, $dbcnx);
$query = "SELECT taxname, taxrate FROM stw_taxoptions";
$list = mysql_query($query, $dbcnx) or die(mysql_error());
$row = mysql_fetch_assoc($list);

..snip html

<form name="form1" method="post">
<select name="audience" id="select1">
<option value="" style="color:ff0000" selected>Select One
</option>
<?php do { ?>
<option value="<?php echo $row['ID']?>">
<?php echo $row['taxname']?></option>
<?php
} while ($row = mysql_fetch_assoc($list)); 
  $rows = mysql_num_rows($list);
  if($rows > 0) {
      mysql_data_seek($list, 0);
	  $row = mysql_fetch_assoc($list);
	  echo $row['taxname'];
 }
?>
</select>
</form>

I don't know if it's good code but it seems to work :rolleyes:
At least, just for the 'taxname'.

RE:

<input name="taxoption[]" type="checkbox" value="1">
<input type="hidden" name="mtax[]" value="<?=$row["taxrate"]?>">
<input type="hidden" name="mcity[]" value="<?=$row["cityname"]?>">

When submit this will give you three array, with isset(taxoption[$n]) if checked, not set else.

Can you please explain a bit more? I don't know where to put this, and still missing how to actually write/insert the data into the 2nd table.

I also just realized, that after the 1st time, if I want to make changes, I need some way to delete all the records in the 2nd table BEFORE re-inserting...or else I could end up with duplicates and unwanted entries which may have been "unchecked" on the Master (1st) page.

OHHHhhhhhhhhhhh....

bad76

If you write like this

<?php do { ?> 
<TD width="10" align="right">
   <?php echo $row['taxrate'];?>
</TD> 
<TD align="center>
   <input name="taxoption[]" type="checkbox" value="1">
   <input type="hidden" name="mtax[]" value="<?=$row["taxrate"]?>"> 
   <input type="hidden" name="mcity[]" value="<?=$row["cityname"]?>"> 
</TD> 
<TD align="left"><?php echo $row['cityname']; ?></TD> 
</TR> 
<?php } while ($row = mysql_fetch_assoc($list));?>

when you submit, in the second page you have $taxoption[], $mtax[] and $mcity[] arrays.

You delete all your entry. Now, for each one city, if isset($taxoption[$i]), you can do any insert using $mtax[$i] and $mcityi[$i]

If num of cities is 100:

 
//DELETE * FROM your_db_table

for($i=0; $i<100; $i++)
{
   if(isset($taxoption[$i]))
        // INSERT INTO your_db_table VALUES(0,$mtax[$i],$mcity[$i])
}

I hope this make a sense...

phplearner

RE:

for($i=0; $i<100; $i++) 
{ 
   if(isset($taxoption[$i])) 
        // INSERT INTO your_db_table VALUES(0,$mtax[$i],$mcity[$i]) 
}

Does this go at the top of the page... BEFORE the <form>??? I am not sure what tag to use except perhaps:

  <form name="form1" method="post">

???

Thank you for all your help. Sorry I am not doing too well with everything 🙁

phplearner

ARRRRGGGHHHHH...

I changed "col" to "row" :

<style> 
.row0 {background-color:#d8d8d8} 
}
.row1 {background-color:#f2f2f2}
}
</style>

...and added a Submit but not sure what value to put and don't think I have the $i++ in the correct place/format.

RE:

when you submit, in the second page you have $taxoption[], $mtax[] and $mcity[] arrays. 

You delete all your entry. Now, for each one city, if isset($taxoption[$i]), you can do any insert using $mtax[$i] and $mcityi[$i]

The Page 1 data is not going directly to Page 2, but to the 2nd MySQL Table. Maybe I am not understanding you???

Thank you for helping...I want to understand this!!!

Regards,

phplearner

It is now 2:30AM (local)...blurry eyed...falling asleep, but still trying to get this to work. I can not figure out the error on the "INSERT" part.

Also tried to put in an Error Message if no checkboxes selected by hacking up another script here. Not sure if code is correct. Still unable to get proper alternating table rows ... unsure of where to stick the incrementer.

Here is what I now have:

<?php

$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
  $editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}

$error = "";
if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "form1")  && ($error =="")) {
if ((isset($HTTP_POST_VARS[($taxoption[$i])])) && ($HTTP_POST_VARS[($taxoption[$i])] == "")) {$error .= "You must select at least one option<br>";}
}

for($i=0; $i<100; $i++)  

{  

   if(isset($taxoption[$i]))  

// The next line is still producing an error
// Parse error: parse error, unexpected T_STRING 
// But I can not figure out what it is ;-(

   INSERT INTO stw_taxoptions VALUES (0,$mtax[$i],$mcity[$i])
}

$hostname = "localhost";
$database = "mydb";
$username = "me";
$password = "";
$dbcnx = mysql_connect($hostname, $username, $password) or die(mysql_error());

mysql_select_db($database, $dbcnx);
$query = "SELECT cityname, taxrate FROM stw_city";
$list = mysql_query($query, $dbcnx) or die(mysql_error());
$row = mysql_fetch_assoc($list);

$cityname = " ";
$taxrate = " ";
$numofrows = " " ;
?>

<html>
<head>
<title></title>
<style> 
.row0 {background-color:#d8d8d8} 
}
.row1 {background-color:#f2f2f2}
}
</style> 

</head>
<body>
<center>
<TABLE width="200" BORDER="0" cellpadding="2" cellspacing="2">
<form name="form1" method="POST" action="<?php echo $editFormAction; ?>">
<TR bgcolor="#c1c1c1">
<TD width="10" align="center"><B>Tax</B></TD>
<TD width="20" align="center"><B>Select</B></TD>
<TD align="center"><B>City</B></TD>
</TR>
 <?php do { ?> 
<TR CLASS="row<?=($i&1)?>"> 

// The alternating rows are not working yet

<TD width="10" align="right"> 
   <?php echo $row['taxrate'];?> 
</TD> 
<TD align="center> 
   <input name="taxoption[]" type="checkbox" value="1"> 

// Regarding the value="1" ... in the 2nd table
// each entry must have a separate number (1, 2, 3, etc.)
// perhaps I do not understand how this works

   <input type="hidden" name="mtax[]" value="<?=$row["taxrate"]?>"> 
   <input type="hidden" name="mcity[]" value="<?=$row["cityname"]?>"> 
</TD> 
<TD align="left"><?php echo $row['cityname']; ?></TD> 
</TR> 
<?php } while ($row = mysql_fetch_assoc($list));

// I am not sure how to insert the 'incrementor' code

?> 
<input type="hidden" name="MM_insert" value="form1">
<input name="submit" type="submit" value="Process Configuration">
</form>
  </TABLE>
  </center>
</body>
</html>
<?php
?>

I think I am too tired to continue right now :o

Thank you for all your kind assistance, but sorry I am still not getting something right.

However, I do have the Page 2 working fine now!!!

<form name="form1" method="post">
<select name="taxname" id="select1">
<option value="" style="color:ff0000" selected>Select One
</option>
<?php do { ?>
<option value="<?php echo $row['ID']?>">
<?php echo $row['taxname']?></option>
<?php
} while ($row = mysql_fetch_assoc($list)); 
  $rows = mysql_num_rows($list);
  if($rows > 0) {
      mysql_data_seek($list, 0);
	  $row = mysql_fetch_assoc($list);
	  echo $row['taxname'];
 }
?>
</select>
</form>

bad76

Wait, just a moment.

First: you can do this

for($i=0; $i<100; $i++)   

{   

   if(isset($taxoption[$i]))   

   //INSERT INTO stw_taxoptions VALUES (0,$mtax[$i],$mcity[$i]) 
}

only in the page that is in $editFormAction.

Second: when i say

   //INSERT INTO stw_taxoptions VALUES (0,$mtax[$i],$mcity[$i]) 
   // look, is a comment

i mean this

$query = "INSERT INTO stw_taxoptions VALUES (0,$mtax[$i],$mcity[$i]) "; 
$list = mysql_query($query, $dbcnx) or die(mysql_error());

I'm wrote that because i don't know what db you are using...

phplearner

I am still awake and working now at 3:30AM (local) !!!

Yes, I realized the query and had done this:

$insertSQL = "(INSERT INTO stw_taxoptions (ID,taxname,taxrate) VALUES (0,$mtax[$i],$mcity[$i]))";
mysql_select_db($database, $dbcnx);
$insert = mysql_query($insertSQL, $dbcnx) or die(mysql_error());

But I changed to yours now, however am getting the message:

"Query was empty"

I still do not understand how to put the $i++ in the while ;-(

(Yawn) ... tired!!!

phplearner

FYI, now almost 4:00AM (local).

I //'d out the Error part, and am now getting display (finally) of test cities/tax on Page 1 again, but checkboxes do NOT show!!!

Also, submit does not insert data. Previous test inserted 99 blank entries each time.

If I only have 3 checkboxes selected, then only 3 entries should be inserted. I can not figure out why checkboxes no longer appear!

Now, I must ZZZZZZZZzzzzzzzzzzzzzzzzzzzzz.

Thank you.

bad76

Originally posted by phplearner
FYI, now almost 4:00AM (local).
I //'d out the Error part, and am now getting display (finally) of test cities/tax on Page 1 again, but checkboxes do NOT show!!!
Also, submit does not insert data. Previous test inserted 99 blank entries each time.
If I only have 3 checkboxes selected, then only 3 entries should be inserted. I can not figure out why checkboxes no longer appear! Now, I must ZZZZZZZZzzzzzzzzzzzzzzzzzzzzz.
Thank you.

just type $i++; in do...while loop to do the change of color.
<?php
$i=0;
do { $i++;
...
} while(...)
?>

What means checkboxes do not show? Get a look to HTML produced by php...

I've used 100 for any example, you have to use the right value.

Good ZZZZZZZZzzzzzzzzzzzzzzzzzzzzz. 😃

see you

phplearner

Originally posted by bad76
just type $i++; in do...while loop to do the change of color.
<?php
$i=0;
do { $i++;
...
} while(...)
?>

Ah ha ... this now works GREAT! Thanks.

What means checkboxes do not show? Get a look to HTML produced by php...

Well, I have tried:

<?php echo '<input name="taxoption" type="checkbox" value="citynameplustaxrate">';?>

The above worked before but not now!!!

...html...
<TD align="center> 
   <input name="taxoption[]" type="checkbox" value="1"> 
   <input type="hidden" name="mtax[]" value="<?=$row["taxrate"]?>"> 
   <input type="hidden" name="mcity[]" value="<?=$row["cityname"]?>"> 
</TD>

Still no checkboxes ;-(

<?php echo '<input name="taxoption[]" type="checkbox" value="1">';?>
<?php echo '<input type="hidden" name="mtax[]" value=$row["taxrate"]>';?> 
<?php echo '<input type="hidden" name="mcity[]" value=$row["cityname"]>';?>

Still no checkboxes appearing.

I have even tried this:

<?php '<input name=\"taxoption\" type=\"checkbox\" value=\"$i\">';?>

I've used 100 for any example, you have to use the right value.

Well, if I only check 3 boxes out of 300 possible, then only those 3 must be written to the 2nd table. But since I don't know how many will actually be checked, can these be 'counted' and then the result used in the loop? Sorry, I am not good at this ;-(

Good ZZZZZZZZzzzzzzzzzzzzzzzzzzzzz. 😃

see you

Thank you, but only a few hours...NOT good!!!

I do not think the 'Error' part works either.

The 'Submit' (Process Configuration) button displays on top of the table output. I have tried to move it below, like for normal forms, but then get replications of it. ARRRGGGHHHH.

BTW, for some reason Test City1 shows 2 times in the display instead of only one time!

bad76

Originally posted by phplearner
Well, if I only check 3 boxes out of 300 possible, then only those 3 must be written to the 2nd table. But since I don't know how many will actually be checked, can these be 'counted' and then the result used in the loop? Sorry, I am not good at this ;-(

If you init $i to 0 at exit you can know how many are checkbox.
Put this value in another hidden field.

 
<?php 
$i=0;
do {  $i++;?>  

<TR CLASS="row<?=($i&1)?>"> 
<TD width="10" align="right"> 
   <?php echo $row['taxrate'];?>  

</TD> 
<TD align="center> 
   <input name="taxoption[]" type="checkbox" value="1"> 
   <input type="hidden" name="mtax[]" value="<?php echo $row["taxrate"]?>"> 
   <input type="hidden" name="mcity[]" value="<?php echo $row["cityname"]?>"> 
</TD> 
<TD align="left"><?php echo $row['cityname']; ?></TD> 
</TR> 
<?php } while ($row = mysql_fetch_assoc($list)); ?>
<input type="hidden" name="numofcheck" value="<?php echo $i?>">

For the checkbox i can't understand.
And this

 
...html... 
<TD align="center> 
   <input name="taxoption[]" type="checkbox" value="1"> 
   <input type="hidden" name="mtax[]" value="<?=$row["taxrate"]?>"> 
   <input type="hidden" name="mcity[]" value="<?=$row["cityname"]?>"> 
</TD>

is very strange, because if is really the html you see, the <? tag is not parsed. Try with <?php instead...

phplearner

Well, you are very kind to keep trying to help me here and I thank you very much.

I have tried several additional options but still can not get things to work. Perhaps it will help to put all the code again as I now have it.

<?php
$hostname = "localhost";
$database = "mydb";
$username = "me";
$password = "";
$dbcnx = mysql_connect($hostname, $username, $password) or die(mysql_error());

mysql_select_db($database, $dbcnx);
$query = "SELECT cityname, taxrate FROM stw_city";
$list = mysql_query($query, $dbcnx) or die(mysql_error());
$row = mysql_fetch_assoc($list);


$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
  $editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}

$error = "";
if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "form1")  && ($error =="")) {
if ((isset($HTTP_POST_VARS[($taxoption[$i])])) && ($HTTP_POST_VARS[($taxoption[$i])] == "")) {$error .= "You must select at least one option<br>";}
}

for($i=0; $i<100; $i++)  

{  

   if(isset($taxoption[$i]))  

   $query = "INSERT INTO stw_taxoptions VALUES (0,'$mtax[$i]','$mcity[$i]')";  

   $list = mysql_query($query, $dbcnx) or die(mysql_error());
}

$cityname = " ";
$taxrate = " ";
$numofrows = " " ;
$taxoption[$i] = " ";
$mtax[$i] = " ";
$mcity[$i] = " ";
?>

<html>
<head>
<title></title>
<style> 
.row0 {background-color:#d8d8d8} 
}
.row1 {background-color:#f2f2f2}
}
</style> 

</head>
<body>
<center>
<TABLE width="200" BORDER="0" cellpadding="2" cellspacing="2">
<form name="form1" method="POST" action="<?php echo $editFormAction; ?>">
<TR bgcolor="#c1c1c1">
<TD width="20" align="center"><B>Tax</B></TD>
<TD width="20" align="center"><B>Select</B></TD>
<TD width="50" align="center"><B>City</B></TD>
</TR>

<?php 
$i=0; 
do { $i++; 
?> 
<TR CLASS="row<?=($i&1)?>"> 
<TD width="20" align="right"> 
   <?php echo $row['taxrate'];?> 
</TD> 
<TD align="center> 
   <input name="taxoption[]" type="checkbox" value="<?php echo '1'?>"> 
   <input type="hidden" name="mtax[]" value="<?php echo $row["taxrate"]?>"> 
   <input type="hidden" name="mcity[]" value="<?php echo $row["cityname"]?>"> 
</TD> 
<TD width="50" align="left"><?php echo $row['cityname']; ?></TD> 
</TR> 
<?php } while ($row = mysql_fetch_assoc($list)) 
?>
<input type="hidden" name="numofcheck" value="<?php echo $i?>"> 
?>
<tr>
<td>
<br>
<input type="hidden" name="MM_insert" value="form1">
<input name="submit" type="submit" value="Process Configuration">
</form>
</td>
</tr>
  </TABLE>
  </center>
</body>
</html>
<?php
?>

Maybe I need to have Page 1 (Selection Page1, then Page 2 (Preview Page + final update of Table 2) if all is correct to process.

Then Page 3 can have totally separate to access the updated config info in Table 2.

I have tried so many things but the checkboxes will not appear again like with my original demo.

My version # is now "s" (i.e., a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,yz). Time to start a new file name.

ARRRRGGGHHHHHHHH :mad::mad:

phplearner

OK...now I can see the checkboxes but nothing is getting inserted to Table 2:

<?php 
$i=0; 
do { $i++;
?> 
<TR CLASS="row<?=($i&1)?>"> 

<TD width="20" align="right"><?php echo $row['taxrate'];?>
</TD> 
<TD width="30" align="center">
<?php echo '<input name="taxoption[]" type="checkbox" value="1">';?>
<?php echo '<input type="hidden" name="mtax[]" value=$row["taxrate"]>';?> 
<?php echo '<input type="hidden" name="mcity[]" value=$row["cityname"]>';?> 
</TD>
<TD width="150" align="left"><?php echo $row['cityname'];?>
</TD> 
</TR> 
<?php } while ($row = mysql_fetch_assoc($list))
?>
<input type="hidden" name="numofcheck" value="<?php echo $i;?>"> 

<tr>
<td>
<br>
<input type="hidden" name="MM_insert" value="form1">
<input name="submit" type="submit" value="Process Configuration">
</form>
</td>
</tr>

Perhaps 'hidden field' coding is the problem???

But TAX & Tax Rate still are to the Left instead of Right, and much wider column than either Checkboxes or Cityname.

This is quite bizarre! Also, still getting TWO 'cityname1'

New image at:

Of course, the Error reporting still does not work. :mad:

bad76

Hidden filed are not a problem, is used to use it...

To align right try to rewrite in this order:

<form name="form1" method="POST" action="<?php echo $editFormAction; ?>"> 

<TABLE width="200" BORDER="0" cellpadding="2" cellspacing="2"> 
<TR bgcolor="#c1c1c1"> 
    <!--you can do this also with <TH>, this is bold and centered <TD>-->
   <TD width="20" align="center"><B>Tax</B></TD> 
   <TD width="20" align="center"><B>Select</B></TD> 
   <TD width="50" align="center"><B>City</B></TD> 
</TR> 

<?php $i=0;  do { $i++; ?>  

<TR CLASS="row<?=($i&1)?>"> 
   <TD width="20" align="right"><?php echo $row['taxrate'];?> 
</TD> 
   <TD width="30" align="center"> 
      <?php echo '<input name="taxoption[]" type="checkbox" value="1">';?> 
      <?php echo '<input type="hidden" name="mtax[]" value=$row["taxrate"]>';?>  

      <?php echo '<input type="hidden" name="mcity[]" value=$row["cityname"]>';?>  

   </TD> 
   <TD width="150" align="left"><?php echo $row['cityname'];?> 
</TD> 
</TR> 
<?php } while ($row = mysql_fetch_assoc($list)) ?> 
<tr> 
   <td colspan=3> <!-- this colspan may be important -->
      <br> 
      <input type="hidden" name="MM_insert" value="form1"> 
      <input type="hidden" name="numofcheck" value="<?php echo $i;?>"> 
      <input name="submit" type="submit" value="Process Configuration"> 
   </td> 
</tr> 
</TABLE> 
</form>

TWO 'cityname1' may be is wrong in DB...

Now in the for of next page you have to write:

 
/*
i write $numofcheck directly, but if you need you must use 
$_POST["numofcheck"] or $HTTP_POST_VARS["numofcheck"]
i'm using global on...
*/

for($i=0; $i<$numofcheck; $i++)    

{    

   if(isset($taxoption[$i]))
   {
        $insertSQL = "(INSERT INTO stw_taxoptions (ID,taxname,taxrate) VALUES (0,$mtax[$i],$mcity[$i]))"; 
        mysql_select_db($database, $dbcnx); 
        $insert = mysql_query($insertSQL, $dbcnx) or die(mysql_error()."<br>".$insertSQL);
    }
}

phplearner

Hidden filed are not a problem, is used to use it...
To align right try to rewrite in this order

FANTASTIC!!! This now works fine (except the tax rates themselves are still left-aligned but it is OK). Thank you.
Hmmm... maybe there is a trick to having 8.5 display as 8.50 ???
This would solve the problem.

TWO 'cityname1' may be is wrong in DB...

No, DB is correct (see URL image) so do not understand what is wrong unless it is in the 'looping' process pulling data from DB?

Now in the for of next page you have to write:
/
i write $numofcheck directly, but if you need you must use
$_POST["numofcheck"] or $HTTP_POST_VARS["numofcheck"]
i'm using global on...
/ ..snip..

Oh oh... this must be part of the problem. My ISP runs PHP with new security Default of "Register_globals OFF" 🙁

So, OK... I tried this:

for($i=0; $i<$HTTP_POST_VARS["numofcheck"]; $i++)     

{     

   if(isset ($taxoption[$i])) 
   { 
        $insertSQL = "(INSERT INTO stw_taxoptions (ID,taxname,taxrate) VALUES (0,$mtax[$i],$mcity[$i]))";  

        mysql_select_db($database, $dbcnx);  

        $insert = mysql_query($insertSQL, $dbcnx) or die(mysql_error()."<br>".$insertSQL); 
   } 
}

But I get error: Notice: Undefined index: numofcheck ...

AMAZINGLY, now I do get only the 4 test citynames instead of 5 with #1 duplicated!!!

Question: is 'numofcheck' (with $i) = the total number of displayed checkbox options on Page1, or is it the sub-total of the options which have been 'checked' for input? ONLY 'checked' entries are to be written to the DB table 😃

But I have been thinking...to have all "checked" entries to 1st display on a 2nd Page (a/k/a "Preview" page) BEFORE final submission. That way, if any changes, can Browser-Back to Page 1, but will this require "Sessions"...or do 'hidden' variables automatically pass to 2nd page for displaying?

Maybe form 'action' code on 1st page directs to 2nd page to display ONLY checked entries, with FINAL 'Submit' button to INSERT to MySQL DB Table.

Thank you again for all your kind assistance!

bad76

hmm...

try to remove the first assignement
$row = mysql_fetch_assoc($list);
and use a while instead do..while, may be this work better.

Using $HTTP_POST_VARS[] array is not a problem too.
Just at the start put

$numofcheck=$HTTP_POST_VARS["numofcheck"];
$mtax=$HTTP_POST_VARS["mtax"];
$mcity=$HTTP_POST_VARS["mcity"];

and this is the same as register_globals on

phplearner

sing $HTTP_POST_VARS[] array is not a problem too.
Just at the start put

$numofcheck=$HTTP_POST_VARS["numofcheck"];
$mtax=$HTTP_POST_VARS["mtax"];
$mcity=$HTTP_POST_VARS["mcity"];

Thanks, but I do not understand what you mean by "Just at the start put"...exactly where on the page? BEFORE the for($i=0; $i<$HTTP_POST_VARS["numofcheck"]; $i++) etc., etc. loop?

What about: $taxoption[$i] ???

Thank you.

phplearner

I just tried this:

$taxoption=$HTTP_POST_VARS["taxoption"]
$numofcheck=$HTTP_POST_VARS["numofcheck"]; 
$mtax=$HTTP_POST_VARS["mtax"]; 
$mcity=$HTTP_POST_VARS["mcity"];

for($i=0; $i<$numofcheck; $i++)     

{     

   if(isset ($taxoption[$i])) 
   { 
        $insertSQL = "(INSERT INTO stw_taxoptions (ID,taxname,taxrate) VALUES (0,$mtax[$i],$mcity[$i]))";  

        mysql_select_db($database, $dbcnx);  

        $insert = mysql_query($insertSQL, $dbcnx) or die(mysql_error()."<br>".$insertSQL); 
   } 
}

It gives Error: Parse error: parse error, unexpected T_VARIABLE in ($numofcheck=$HTTP_POST_VARS["numofcheck"]😉

Should perhaps $HTTP_SERVER_VARS be better?