Updating the looped data

[belmon]

Hi,

 

I want to loop out data from DB in <input> and change and update several posts at the same time.

Can you give me a short example, how <input> and maybe foreach could look like?

 

Thanks

[xyph]

Perhaps if you started with some code you've attempted.

[belmon]

My example:

 

<FORM ACTION="edit_price.php" METHOD="POST">

<?

include "db.php";

$sql = mysql_query("select * FROM prices", $conn);

while ($rs= mysql_fetch_array($sql)){

$priceid = $rs['price_id'];

$price = $rs['price'];

 

?><input type="text" name="pprice['.$priceid.']" value="<? echo $price; ?>">

<input type="submit"> </FORM>

 

And the updating code:

 

if ($pprice) {

foreach ($ ????????)

if ($price>0) {

include "db.php";

$sql = mysql_query("UPDATE prices SET price = '$pprice' WHERE price_id = '$priceid'");

}

}

-------------------------------------

 

This code is hypothetical and completely wrong. But maybe something like this.

 

[xyph]

You're on the right track, keep attempting on your own, and fix up a few parse errors.

[belmon]

Thanks for your reply!

 

I already have tried a bit. I appreciate if you correct the code quickly and I promis to learn it for the life.

 

 

 

[xyph]

I'm not here to program for you.

 

If you don't understand the basic syntax, you should learn that first.

[belmon]

I try to get help at other forums.

But I propse to do not answer so to anyone

Thanks and goodbye