[Resolved] How to access multiple variables from form

esilk

I have a form that lists a number of events which is generated from a database table containing the event details.

On the form, each event has a quantity field with names in the series: qty_event1, qty_event2, qty_event3, etc. with the numbers increasing or decreasing based on the number of events in the database table.

The Problem:
On the next screen after submit I must calculate the total fees for all events...

Hard coding the following for each event works, but I need to figure out a way to do this dynamically:

if ($_SESSION[qty_event1]){
$res = mysql_query("SELECT * FROM events where id='$_SESSION[event1_id]'");
$ar = mysql_fetch_array($res);
$event1fee = $_SESSION[qty_event1] * $ar[fee];
}

I thought of using a foreach or while loop, but cannot figure out how to do it since the number that changes is part of the variable name.

Any ideas on a better approach?

Thank you all!

YappyDog

You should be able to use a variable to set your number. You'd probably want to do it in a loop that sets it from 1 to whatever

$x = 1;

if ($SESSION["qty_event$x"]){
$res = mysql_query("SELECT FROM events where id=" . $SESSION["event$x_id"]);
$ar = mysql_fetch_array($res);
$tmp = "event" . $x . "fee";
$$tmp = $_SESSION["qty_event$x"] $ar[fee];
}

devinemke

a few suggestions:

if the segment of the events table you are displaying is relatively small, rather than do several queries in a loop why not just do one to get all the data you are going need to display and process the form. i'm going to assume that the primary key field of the events table is event_id.

$result = mysql_query('SELECT * FROM events');
while ($row = mysql_fetch_assoc($result))
{
	$_SESSION['events'][$row['event_id']] = $row
}

now you have an array $SESSION['events'] that contains everything you need. first build the form:

foreach ($_SESSION['events'] as $key => $value)
{
	echo 'event #' . $key . ' qty: <input type="text" name="qty[' . $key . ']"><br>';
}

then once submitted you can easily total up:

$total = 0;
foreach ($_POST['qty'] as $key => $value)
{
	$total =+  $_SESSION['events'][$key]['fee'] * $value;
}

esilk

The following code worked:

$x = 1; 
while ($x<=$_SESSION[event_qty]){
if ($_SESSION["qty_event$x"]){ 
$qty = $_SESSION["qty_event$x"];
$sessid = $_SESSION["event".$x."_id"];
$res = mysql_query("SELECT * FROM events where id='$sessid'"); 
$ar = mysql_fetch_array($res); 
$tmp = "event" . $x . "fee"; 
$$tmp = $qty * $ar[fee];
$eventfees = $eventfees + $$tmp;
}$x++;}

Thanks for the suggestions which pointed me in the right direction