On Thursday 18 April 2002 00:11, Jennifer Downey wrote:
> I have no takers on this one?
>
> Just to let you know I have been working on this to here is some new code.
> What I need this to do is update the price in the db table.
> if I have on item it is fine. If I have two items it won't update the
> first items price but will the second. if I try to enter a price in the
> first items textbox it doesn't update and then deletes the second item's
> price.
>
> If I have 15 items and using one submit button how do I get this to update
> all items that are listed?
>
> $query = "SELECT uid, id, name, image, type, quantity, price FROM
> {$config["prefix"]}_shop WHERE uid = {$session["uid"]}";
> $ret = mysql_query($query);
> while($row = mysql_fetch_array($ret))
> {
> $uid = $row['uid'];
> $id = $row['id'];
> $name = $row['name'];
> $image = $row['image'];
> $iquantity = $row['quantity'];
> $itype = $row['type'];
> $iprice = $row['price'];
>
> if($update)
> {
> $eprice = '$price[]';
I don't know what else is wrong with your code, but this is *definitely*
going to cause problems.
I assume you mean:
$eprice = $price[];
But even this is wrong. You should probably be keeping a counter, eg $i, then
use:
$eprice = $price[$i];
[snip]
> value=\"\" name=\"price[]\" size='8'
value=\"\" name=\"price[$i]\" size='8'
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
We have a equal opportunity Calculus class -- it's fully integrated.
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
