print entire record from DB?

bufhal

Hello. I am having a problem with print for PHP. I have tried all the examples in my text. I am trying to print entire row from database for each chosen dropdown: Date, Agency or City when a user clicks a item from that specific dropdown..
Do I need another file on server for a form or can I put all code on index.php main web page(e.g. results.php)?
Here is what I have:
$date = '<select name="date">';
$agency = '<select name="agency">';
$city = '<select name="city">';

$result = mysql_query("SELECT date,agency,city FROM agencies") or die(mysql_error());
while($row = mysql_fetch_array($result))
{
$date .= '<option value="'.$row["date"].'>'.$row["date"].'</option>';
$agency .= '<option value="'.$row["agency"].'>'.$row["agency"].'</option>';
$city .= '<option value="'.$row["city"].'>'.$row["city"].'</option>';
}
$date .= '</select>';
$agency .= '</select>';
$city .= '</select>';

Then the dropdowns in the "body" of the HTML:

date: <?=$date?>  
city: <?=$city?>  
agency: <?=$agency?>

I am really trying to understand.. any help is appreciated..

tude-marie

I would throw the data into arrays and just parse them out...

$i = 0;

$data = mysql_query("SELECT date, agency, city FROM agencies");
while($rs = mysql_fetch_array($data))
{
   $date[$i] = $rs['date'];
   $agency[$i] = $rs['agency'];
   $city[$i] = $rs['city'];

   $i++;
}

$date_out = '<select name="date">';
foreach($date as $key => $val)
{
   $date_out .= '<option>'.$val.'</option>';
}
$date_out .='</select>';

$agency_out = '<select name="date">';
foreach($agency as $key => $val)
{
   $agency_out .= '<option>'.$val.'</option>';
}
$agency_out .='</select>';

$city_out = '<select name="date">';
foreach($city as $key => $val)
{
   $city_out .= '<option>'.$val.'</option>';
}
$city_out .='</select>';


echo $date_out;
echo $agency_out;
echo $city_out;

bufhal

thank you, tude-marie;
but how can the results of what a person clicks on appear in a pop up window? Do I need to make another file, results.php, and put it on the server?

bufhal

You know tude-marie, your code worked until I tried to get results in pop up windows in select statements-now it is parse error time!
...If you find a minute..Here is where I am:
<?PHP
$hostName = "db.com";
$userName = "wny";
$password = "immunize";
$dbName = "wnyorg";

// make connection to database
mysql_connect($hostName, $userName, $password) or die("Unable to connect to host $hostName");

mysql_select_db($dbName) or die("Unable to select database $dbName");

$i = 0;

$data = mysql_query("SELECT date, agency, city FROM agencies");
while($rs = mysql_fetch_array($data))
{
$date[$i] = $rs['date'];
$agency[$i] = $rs['agency'];

$city[$i] = $rs['city'];

$i++;
}

$date_out .= '<select name="date" onchange="window.open('results.php?date='+this.value, 'agencyWin', 'location=yes,left=20,top=20');">
';
foreach($date as $key => $val)
{
$date_out .= '<option>'.$val.'</option>';
}
$date_out .= '</select>';

$agency_out .= '<select name="agency" onchange="window.open('results.php?agency='+this.value, 'agencyWin', 'location=yes,left=20,top=20');">';
foreach($agency as $key => $val)
{
$agency_out .= '<option>'.$val.'</option>';
}
$agency_out .='</select>';

$city_out .= '<select name="city" onchange="window.open('results.php?city='+this.value, 'agencyWin', 'location=yes,left=20,top=20');">
';
foreach($city as $key => $val)
{
$city_out .= '<option>'.$val.'</option>';
}
$city_out .='</select>';

echo $date_out;
echo $agency_out;
echo $city_out;
?>