rather than all the hidden fields and stuff you guys are trying to do - why not just build the array variable you want, then save it into a session, on the next page, access the session variable and wallah - there's your array, still in tact and just as you left it (ie. containing all the info you want, not the word "Array")
HTH beua // -----Original Message----- // From: jas [mailto:[EMAIL PROTECTED]] // Sent: Monday, 25 February 2002 5:50 PM // To: [EMAIL PROTECTED] // Subject: Re: [PHP-DB] Passing contents of array on as variables... // // // Bjorn, // I just wanted to thank you for giving me alot of insight // into what I was // trying to accomplish however, due to time restraints I have // decided to do it // a different way by pulling the entries into a select box // that a customer can // use to delete the different items. Once again, thanks a ton!!!! // Jas // // "Jas" <[EMAIL PROTECTED]> wrote in message // [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... // > Ok, I think I understand what you are talking about. So // now I know what I // > need to accomplish, and would you happen to know of a good // place to learn // > about something like this? For some reason this function // keeps seeming to // > elude me and if you know of a good tutorial on how to // accomplish this I // > would appreciate it. Thanks again, // > Jas // > <[EMAIL PROTECTED]> wrote in message // > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... // > > 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],$c // ar_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 // -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php