loop, post then show array items

j0s3

i have a page that returns a bunch of rows with some data from a query.

i've added an input box to the row along with a counter (input type="text" name="text<?=$counter; ?>") so that when the page loads, all the textboxes that appear become part of an array (text1, text2 and so on)

when the page loads, the rows are populated with data, except for these input boxes which are empty.

the user then selectes whatever rows are required (lets say 1,3 and 5) and enters data in these empty inputboxes, then submits the page

the next bit is what i can't get working:

a new page opens displaying the rows that were selected in the previous page. i also want to echo the contents of the input boxes from the rows that were selected

if i was echoing all the results, i could echo the array one by one, but here's the tricky bit: the rows selected (i.e. the input boxes that have data) are not 1,,3,4, etc... they can be any! so i need to figure out which array items have data and display them

i would really appreciate any pointers (with syntax, as i'm new to php)

thanks very much
jg

liquorvicar

How are your users selecting the rows? If it's via checkboxes, what you need to do is to go through your $POST/$GET array and build an array of the rows they've selected. You can then use a query like:

$sql = "SELECT * FROM table WHERE idField in (".implode(',',$selectedArray).")";

j0s3

yes its via checkboxes,

the submit button works fine and the new page loads the selected rows fine. its just the new input box that i've added (its not related to the data - as its not a field in the db, so there's nothing to query on the db

i'll explain the purpose see if that makes more sense

1 - the rows in page1 display a bunch of products from the db

2 - i have now added an inputbox to the rows where the user can enter a price per weight (this is not a constant)

3 - the user selects a few rows (tickboxes) and enters the price per weight figure into the input boxes in the selected rows

4 - user submits the form, and page2 loads

5- page 2 shows the rows that where seected, AND an extra field which is a calculation of the figure entered in page1 (price per weight) x something else.

6 - this page is then printed and the user has a record of the order

NOTE: the $priceperweight is not held in the db

hope that makes more sense

thanks!