creating variables from query...

Anon

here is my problem...
I am trying to query a mysql database for all the records in a table, once I have the sql query complete I need to put those results in either an array or individual variables that can be passed to a confirmation page for deletion. Here is what I have so far... I am not asking you to write something for me, I simply need to find a tutorial on how to accomplish this.
<?php
require '../path/to/db.php';
$result = @("SELECT * FROM cur_inv",$dbh) or die("Could not execute query, please try again later");
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>";
$count = -1;
while ($myrow = mysql_fetch_row($result)) {
$count ++;
echo "<tr><td width=\"30%\"><B>Type Of Car: </B></td><td>";
printf(mysql_result($result,$count,"car_type"));
echo "</td><td><input type=\"checkbox\" name=\"id[]\" value=\"".$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";
}
echo "<tr><td><input type=\"submit\" name=\"delete\" value=\"delete\"></td></tr></form></table>";
?>
As you can see the query and results are displayed on the page, I need to know how I can take these results or records and make them into an array. Please help!!!??? Thanks in advance,
Jas
Oh here is the confirmation code as well...
<?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\" VALUE=\"$car_type\">
<INPUT TYPE=\"hidden\" NAME=\"car_model\" VALUE=\"$car_model\">
<INPUT TYPE=\"hidden\" NAME=\"car_year\" VALUE=\"$car_year\">
<INPUT TYPE=\"hidden\" NAME=\"car_price\" VALUE=\"$car_price\">
<INPUT TYPE=\"hidden\" NAME=\"car_vin\" VALUE=\"$car_vin\">
<tr>
<td align=\"center\" colspan=\"3\"><font size=\"4\"><B>Confirm Record Deletion</B></font><hr color=\"333333\"></td>

</tr>
<tr>
<td width=\"30%\"><B>Type Of Car: </B></td>
<td>$car_type</td>
</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>
<tr>
<td colspan=\"3\"><hr color=\"333333\"></td>
</tr>
<tr>
<td><input type=\"submit\" name=\"delete\" value=\"delete\"></td>
</tr>
</form>
</table>");
?>

Anon

I believe that what you want can be accomplished by modifying this line in your first file:

echo "</td><td><input type=\"checkbox\" name=\"id[]\" value=\"".$myrow[id]."\">remove</td></tr>\n";

to this:

echo "</td><td><input type=\"checkbox\" name=\"id[".$myrow[id]."]\">remove</td></tr>\n";

then in your second page, you can do something like:

while (list($key,$val)=each($id)) {
// list your id's here
// if you want associated info, get it from the table again
}

Anon

you emailed me:

Still a newbie here so bear with me... =)
while (list($key,$val)=each($id)) {
// then list my items
$id = $row["id"];
$car_type = $row["car_type"];
$car_model = $row["car_model"];
$car_year = $row["car_year"];
$car_price = $row["car_price"];
$car_vin = $row["car_vin"];
}
is this right? As of right now I have been able to query the db and associate a unique value for each record which I accomplished with this snippit...
<?php
require '../scripts/db.php';
$result = @("SELECT * FROM cur_inv",$dbh) or die("Could not execute query, please try again later");
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>";
$count = -1;
while ($myrow = mysql_fetch_array($result)) {
    $id = $row["id"];
    $car_type = $row["car_type"];
    $car_model = $row["car_model"];
    $car_year = $row["car_year"];
    $car_price = $row["car_price"];
    $car_vin = $row["car_vin"];
    $count ++;
echo "<tr><td width=\"30%\"><B>Type Of Car: </B></td><td>";
printf(mysql_result($result,$count,"car_type"));
echo "</td><td><input type=\"checkbox\" name=\"id[]\" value=\"".$myrow[id]."\">remove</td></tr>\n";
However... click the delete button to remove the record(s) the $car_type, $car_model etc are not passed to the confirmation page... I think I just need to better understand how to query the db and put the results into variables that can be passed as unique records. Any more insight you have would be great!! Thanks in advance,

Jas

you have obviously misunderstood the point of message boards. They aren't here to just solve YOUR problems, they are here to solve everyone's problems. solving them privately doesn't help anyone else.

Anon

now, that is not what I suggested - read the code again.

the part you have referred to is for the second "confirmation" page - note that I also vhanged the other line in the first page.

for the second page, you would list the ids by doing this is the loop:

print $key;

then you can get the records from the DB with that information if you must print it again:

select * from table where id=$key

then print it out

again, you have to change the naming scheme on the second page so you know what id's to delete.

a different (and in my opinion better) way to accomplish all this would be to do a self-processing for and use separate forms for each line and just a have a delete button for each line.

Anon

I apologize for emailing you directly... I have never used this message board. In any event, I think the thing that I am having a hard time with is where to find some good step-by-step tutorials on how to create arrays or variables from a table query. I have looked on php.net under the links section but could not find anything in regards to this specific problem. If you know of any or could just explain it a little more clearly that would help me out a ton. Thanks again,
Jas

Anon

I have no problem with you emailing me, my point is that by asking questions here on the boards, everyone benefits.

here is a quick way to create an array from a query (rough-coded, not exact):

$sql="select id from table";
$result=mysql_query($sql);
while ($row=mysql_fetch_array($result)) {
$my_array[]=$row['id'];
}

that help?