Posted by flamer die.spam@hotmail.com on 10/16/06 21:27

mantrid wrote:

> 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

depends how your doing your loop, cheaters way: (inside your loop)
if (empty($val)) {$val = " "}

Flamer.

• Next in forum: Re: preg_match explanation
• Prev in forum: Re: Why not generate static pages instead of dynamic?
• Thread view: Re: using a set of arrays togther and keeping data in sync?

[Reply to this message]