how to do dynamic update

cretaceous

hi - I have a table that contains the number of items in stock - each item comes in five sizes - so one item id, five columns

I can draw it up on screen no problem but I want to have all the stock fields for all the items open to editing at any time - not the more usual single id edit

...when I try to Update, I can't get an item id to identify which table rows on the drawn up html table it should look at to get the quantities

(I don't need 'Insert', as the table is 'added to' when items are inserted elsewhere)

I'm not sure if the $$ thing might help (I'm guessing - I don't really know what $$ is) as I've tried naming the fields:
$myid.$myquantity but then it just becomes a string... and $newpointer=eval($myid.$myquantity) doesn't work

I'm not an expert at this so any simple help much appreciated!

Maybe it's just a bad idea to have all fields open to editing?
I can append more script if anyone thinks it would help.

thanks

tsinka

Hi,

I hope I understood you completely ...

you can name the fields so that they will be interpreted as multidimensional arrays after submission.

Simple example:

<html>
  <head>
    <title>
      This is the title
    </title>
  </head>
  <body>
<?PHP
  if (isset($_POST['submit'])) {
    print_r($_POST['inp']);
  }
?>

<form name="testform" action="<?=$_SERVER['PHP_SELF']?>" method="post">
  <input type="text" name="inp[0][0]" />
  <input type="text" name="inp[0][1]" />
  <input type="text" name="inp[0][2]" />
  <input type="text" name="inp[0][3]" />
  <input type="text" name="inp[0][4]" />
  <br />
  <input type="text" name="inp[1][0]" />
  <input type="text" name="inp[1][1]" />
  <input type="text" name="inp[1][2]" />
  <input type="text" name="inp[1][3]" />
  <input type="text" name="inp[1][4]" />      
  <br />
  <input type="submit" name="submit" value="Test..." />
</form>
  </body>
</html>

Use e.g. a while/for loop and inside that loop
item[$itemid][$sizeid] as name for the input.

After that you can access the posted value for e.g. itemid=5 and sizeid=3 with

$_POST['item'][5][3]

Thomas

cretaceous

thankyou Thomas - that looks like the answer, fantastic!
- I'll try it later

cretaceous

yup that worked - thanks

it took me a while to realise that another array that suplied the correct sequence of ids wouldn't pass as a variable on submit -

so eventually I realised I could just rebuild that array with new queries at the top of the page