$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