Posted by mantrid on 10/16/06 20:18

Im using arrays generated from my records displayed in a table on my site to
update the corresponding records in a mysql database ie

on the web page
col1 col2 col3
1 2 2
1 6
2 7 4

which I post to next page as col1array col2array col3array problem is some
of the fields in the site's table are blank
so the arrays are not in sync

ie
col1array col2array col3array
1 2 2
1 7 6
2 4

so when I loop through the arrays feeding the values into an update sql the
wrong data is going into the wrong rows in the mysql table ie

field1 field2 field3
row1 1 2 2
row2 1 7 6
row3 2 4

instead of

field1 field2 field3
row1 1 2 2
row2 1 6
row3 2 7 4

how do I get the data in the arrays to stay in sync, in otherwords how can
I get the arrays to somehow recognise blanks in the site's table

Thanks
Ian

[Back to original message]