Re: Foreach and mydql_query problem

On Jul 22, 2013, at 1:19 AM, Karl-Arne Gjersøyen <karlarneg@gmail.com> wrote: > Hello again. > I have this this source code that not work as I want... > > THe PHP/HTHML form fields is generated by a while loop and looks like this: > > <input type="number" name="number_of_items[]" size="6" > value="<?hp > echo "$item"; ?>" required="required"> > > > the php source code look like this: > <?php > if(!empty($_POST['number_of_itemsi'])){ > include('../../connect.php'); > > foreach($number_of_items as $itemi){ > echo "$itemi<br>"; > > $sql = "UPDATE item_table SET number_item = '$item' WHERE date > = '$todays_date' AND sign = '$username'"; > mysql_query($sql,$connect) or die(mysql_error()); > } > } > > ?> > > The problem is: > Foreach list every items as expected in PHP doc and I thought that $sql and > mysql_query should be run five times when I have five items. > But the problem is that only the very last number_of_items is written when > update the form.. > I believe this is becayse number_of_items = '$item in $sqk override every > earlier result. > > So my querstion is. How to to update the database in this case? > > Thanks again for your good advice and time to help me. > > Karl' Either the code you posted isn't the actual code, or if it is, the errors should be rather obvious. Post *actual* code.