One problem I see is that you are sending all of the values for all of your
fields (except the id field) from the first page to the second page, not just
the ones that are checked, so even if it was working properly, you would get
a list of all items in the table, not just the checked items. You need to
send the array of id's (since this is the name for the checkbox) from the
first page to the second one (again in the checkbox form element, you did not
put a value on it).
What your first page is currently doing is pulling all of the information out
of the database. Then as soon as you pull each item out, you are putting it
into an hidden form element array, ie. $car_type[], $car_model[], etc.
regardless of whether the checkbox is checked or not to pass to the next
page. You do not know if the checkbox is checked or not until the next page
when it looks at the values in the id array. On the second page, you need to
look at the id array and then (through a database call) pull the row from the
table for each id in the array.
HTH
MB
jas <[EMAIL PROTECTED]> said:
> $i=0;
> while
> ($car_type[$i],$car_model[$i],$car_year[$i],$car_price[$i],$car_vin[$i]) {
> $i ++;
> }
> Is what I added and this is what is being output to the screen at this
> point...
> =0; while (,,,,) { ++; }
> now i am still too new to php to understand why it is not putting the
> contents of the array into my hidden fields like it does on my first page (i
> can see them when I view source).
> <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > When you call your $car_type in the second page, you need to set a
> variable
> > starting at 0 and call it as $car_type[0] and loop through all of the
> values
> > in the array.
> >
> > ie.
> >
> > $i=0;
> > while ($car_type[$i]) {
> >
> > I have added more code below that should help.
> >
> > MB
> >
> >
> > jas <[EMAIL PROTECTED]> said:
> >
> > > Yeah, tried that and it still isnt passing the contents of the array as
> a
> > > varible to the confirmation page for deletion. I am at a loss on this
> one.
> > > <[EMAIL PROTECTED]> wrote in message
> > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > > You didn't add the value part of the hidden element, ie.
> > > >
> > > > <INPUT TYPE=\"hidden\" NAME=\"car_type\" value=\"$myrow[car_type]\">
> > > >
> > > > You were naming the field as an array with no value.
> > > >
> > > > if you want to pass this as an array of values, you would need to use:
> > > >
> > > > <INPUT TYPE=\"hidden\" NAME=\"car_type[]\" value=\"$myrow[car_type]\">
> > > >
> > > > Give that a try and see if it works.
> > > >
> > > > HTH
> > > >
> > > > MB
> > > >
> > > >
> > > > jas <[EMAIL PROTECTED]> said:
> > > >
> > > > > As of right now if you run the php script and view source on the
> page
> > > you
> > > > > can see that it does place the content of db table into array... ex.
> > > > > <B>Current Inventory</B></font><hr color="333333"></td></tr>
> > > > > <INPUT TYPE="hidden" NAME="car_type[Ford]">
> > > > > <INPUT TYPE="hidden" NAME="car_model[Ranger]">
> > > > > <INPUT TYPE="hidden" NAME="car_year[1999]">
> > > > > <INPUT TYPE="hidden" NAME="car_price[5600]">
> > > > > <INPUT TYPE="hidden" NAME="car_vin[no vin]">
> > > > > <tr><td width="30%"><B>Type Of Car: </B></td><td>Ford</td><td><input
> > > > > type="checkbox" name="id[1]">remove</td></tr>
> > > > > but on the following page (after selecting items to delete) it just
> > > displays
> > > > > the word array for each field (i.e. car_type etc.)
> > > > >
> > > > > "Jas" <[EMAIL PROTECTED]> wrote in message
> > > > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > > > > Oops... yeah its a monday.
> > > > > > Bjorn, I reverted back to my original code because I was getting
> > > > > confused...
> > > > > > Here is page one...
> > > > > > <?php
> > > > > > // Database connection paramaters
> > > > > > require '../path/to/db.php';
> > > > > > // SQL statement to get current inventory
> > > > > > $result = @mysql_query("SELECT * FROM cur_inv",$dbh) or die("Could
> not
> > > > > > execute query, please try again later");
> > > > > > // Creating table to make data look pretty
> > > > > > echo "<table border=\"0\" class=\"table-body\"
> width=\"100%\"><form
> > > > > > name=\"rem_inv\" method=\"post\" action=\"rem_conf.php3\">
> > > > > > <tr><td align=\"center\" colspan=\"3\"><font size=\"4\"><B>Current
> > > > > > Inventory</B></font><hr color=\"333333\"></td></tr>";
> > > > > > // Start to count number of records in selected table and loop
> until
> > > done
> > > > > > $count = -1;
> > > > > > while ($myrow = mysql_fetch_array($result)) {
> > > > > > $count ++;
> > > > > > // Begin placing them into an hidden fields and then array
> > > > > > echo "
> > > > > > <INPUT TYPE=\"hidden\" NAME=\"car_type[".$myrow[car_type]."]\">
> > > > > > <INPUT TYPE=\"hidden\" NAME=\"car_model[".$myrow[car_model]."]\">
> > > > > > <INPUT TYPE=\"hidden\" NAME=\"car_year[".$myrow[car_year]."]\">
> > > > > > <INPUT TYPE=\"hidden\" NAME=\"car_price[".$myrow[car_price]."]\">
> > > > > > <INPUT TYPE=\"hidden\" NAME=\"car_vin[".$myrow[car_vin]."]\">
> > > > > > // Place items on separate cells in html table
> > > > > > <tr><td width=\"30%\"><B>Type Of Car: </B></td><td>";
> > > > > > printf(mysql_result($result,$count,"car_type"));
> > > > > > // Create checkbox so user can delete items if needed
> > > > > > echo "</td><td><input type=\"checkbox\"
> > > > > > name=\"id[".$myrow[id]."]\">remove</td></tr>\n";
> > > > > > echo "<tr><td width=\"30%\"><B>Model Of Car: </B></td><td>";
> > > > > > printf(mysql_result($result,$count,"car_model"));
> > > > > > echo "</td></tr>\n";
> > > > > > echo "<tr><td width=\"30%\"><B>Year Of Car: </B></td><td>";
> > > > > > printf(mysql_result($result,$count,"car_year"));
> > > > > > echo "</td></tr>\n";
> > > > > > echo "<tr><td width=\"30%\"><B>Price Of Car: </B></td><td>$";
> > > > > > printf(mysql_result($result,$count,"car_price"));
> > > > > > echo "</td></tr>\n";
> > > > > > echo "<tr><td width=\"30%\"><B>VIN Of Car: </B></td><td>";
> > > > > > printf(mysql_result($result,$count,"car_vin"));
> > > > > > echo "</td></tr><tr><td colspan=\"3\"><hr
> > > color=\"333333\"></td></tr>\n";
> > > > > > }
> > > > > > // End loop and print the infamous delete button
> > > > > > echo "<tr><td><input type=\"submit\" name=\"delete\"
> > > > > > value=\"delete\"></td></tr></form></table>";
> > > > > > ?>
> > > > > > Here is page two...
> > > > > > <?php
> > > > > > print("
> > > > > > <table border=\"0\" class=\"table-body\" width=\"100%\">
> > > > > > <form name=\"rem_inv\" method=\"post\" action=\"done2.php3\">
> > > > > > <INPUT TYPE=\"hidden\" NAME=\"car_type[".$myrow[car_type]."]\">
> > > > > > <INPUT TYPE=\"hidden\" NAME=\"car_model[".$myrow[car_model]."]\">
> > > > > > <INPUT TYPE=\"hidden\" NAME=\"car_year[".$myrow[car_year]."]\">
> > > > > > <INPUT TYPE=\"hidden\" NAME=\"car_price[".$myrow[car_price]."]\">
> > > > > > <INPUT TYPE=\"hidden\" NAME=\"car_vin[".$myrow[car_vin]."]\">
> > > > > > <tr>
> > > > > > <td align=\"center\" colspan=\"3\"><font size=\"4\"><B>Confirm
> > > Record
> > > > > > Deletion</B></font><hr color=\"333333\"></td>
> > > > > > </tr>
> >
> > Here is where above loop code would go and $car_type, $car_model, etc.
> would
> > be called as $car_type[$i], $car_model[$i], etc.
> >
> >
> > > > > > <tr>
> > > > > > <td width=\"30%\"><B>Type Of Car: </B></td>
> > > > > > <td>$car_type</td> // here is where it prints the word "array"
> > > instead of
> > > > > > type of car
> > > > > > </tr>
> > > > > > <tr>
> > > > > > <td width=\"30%\"><B>Model Of Car: </B></td>
> > > > > > <td>$car_model</td>
> > > > > > </tr>
> > > > > > <tr>
> > > > > > <td width=\"30%\"><B>Year Of Car: </B></td>
> > > > > > <td>$car_year</td>
> > > > > > </tr>
> > > > > > <tr>
> > > > > > <td width=\"30%\"><B>Price Of Car: </B></td>
> > > > > > <td>$car_price</td>
> > > > > > </tr>
> > > > > > <tr>
> > > > > > <td width=\"30%\"><B>VIN Of Car: </B></td>
> > > > > > <td>$car_vin</td>
> > > > > > </tr>
> >
> > increment $i and
> > end loop
> >
> >
> > > > > > <tr>
> > > > > > <td colspan=\"3\"><hr color=\"333333\"></td>
> > > > > > </tr>
> > > > > > <tr>
> > > > > > <td><input type=\"submit\" name=\"delete\"
> value=\"delete\"></td>
> > > > > > </tr>
> > > > > > </form>
> > > > > > </table>");
> > > > > > ?>
> > > > > >
> > > > > > <[EMAIL PROTECTED]> wrote in message
> > > > > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > > > > > Let's see what your code looks like now and where it is
> returning
> > > the
> > > > > > > word "array". That might help determine where the problem lies
> now.
> > > > > > >
> > > > > > > MB
> > > > > > >
> > > > > > > jas <[EMAIL PROTECTED]> said:
> > > > > > >
> > > > > > > > Ok to this point I have been able to query a database table,
> > > display
> > > > > the
> > > > > > > > results in tables and within a form. As of yet I have been
> able
> > > to
> > > > > > insert
> > > > > > > > the contents of the db query into an array for further
> processing.
> > > > > > However,
> > > > > > > > when I try to pass the contents of that array on to another
> page
> > > to
> > > > > > delete
> > > > > > > > selected records from the db it only displays the word
> "array".
> > > Not
> > > > > > quite
> > > > > > > > sure where I need to go from here... Any insight would be a
> great
> > > > > help.
> > > > > > > > Thanks in advance,
> > > > > > > > Jas
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > --
> > > > > > > > PHP Database Mailing List (http://www.php.net/)
> > > > > > > > To unsubscribe, visit: http://www.php.net/unsub.php
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > --
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > PHP Database Mailing List (http://www.php.net/)
> > > > > To unsubscribe, visit: http://www.php.net/unsub.php
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> >
> >
> >
> > --
> >
> >
> >
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
