[SOLVED] [PHP][MYSQL] dropdown - select ID and display its ROW in DIV or new page

[karol65]

Hi,

 

I am completely newbie. I have created dropdown list, that reads some vars form msql Dbase. The thing is I would like to allow, by clicking on selected position form dropdown, to display all rows (form ID) in new or new window.

 

my code:

 

<?php

$query = mysql_query("SELECT * FROM table ORDER BY id");

echo '<select name="ids" style="width :500px">';

while($row = mysql_fetch_array($query))

{

echo '<option name="'.$row['id'].'">'.$row['name'].', CMD: '.$row['cmd'].', Date: '.$row['StartDate'].'</option>';

}

echo '</select>';

?>

 

I don't know how to pass those vars (or how to declare it). Thanks for any suggestions.

 

[MadTechie]

your list is probably in a form,

 

read here

[karol65]

OK, thanks for reply. I get the point, but I cannot input select list with all records in one place. Instead of this I have (based on script below):

 

|------------||--------------||--------------||------------------| (numbers of those fields = numbers of IDs in table)

 

And how to pass those vars by submit button?

 

<?php include 'config.php'; ?>

 

<?php

 

 

$sql = "SELECT name,StartDate,id FROM `my_table` ORDER BY `id` ASC";

$result = mysql_query($sql) or die (mysql_error());

echo "<select name=\"\" id=\"\">";

while ($row = mysql_fetch_array($result)){

  extract ($row);

  echo "<form action=\"sum.php\" method=\"post\">";

  echo "<select name=\"genfile\" OnChange=\"submit();\">";

  echo "<option>-------</option>";

 

echo "<option value=\"$id\">$name - $cmd - $StartDate</option>";

}//Ends while

//echo "</select>";

echo "<input type=\"submit\">";

echo "</form>";

echo "<br />";

echo "<br />";

 

 

 

 

 

?>

[karol65]

Now I have something like this:

 

<?php

 

 

 

 

$sql = "SELECT * FROM `table` ORDER BY `id` ASC";

$result = mysql_query($sql) or die (mysql_error());

//echo "<select name=\"\" id=\"\">";

 

while ($row = mysql_fetch_array($result)){

  extract ($row);

  echo "<form action=\"sum.php\" method=\"post\">";

//  echo "<select name=\"genfile\"  value=\"$id\" OnChange=\"submit();\">";

  echo "<option value=\"$id\" OnChange=\"submit();\" > $name - $cmd - $StartDate - $t_letter_code_ef </option>";

 

 

// echo "<value=\"$row[id]\"> $row[t_letter_code_ef]</option>";

 

 

//echo "<option value=\"$id\">$name - $cmd - $StartDate</option>";

}//Ends while

//echo "</select>";

echo "<br />";

echo "<br />";

echo "<input type=\"submit\">";

echo "</form>";

echo "<br />";

echo "<br />";

 

 

?>

 

But this is not a select list, it displays all as a static list, I want to make it clickable, like real select list (dropdonw= and send all row to sum.php. Any idea how to do this?

[MadTechie]

untested

<?php
if(isset($_POST['Test']))
{
echo $_POST['Test']."SELETED<br>";
}
$sql = "SELECT * FROM `table` ORDER BY `id` ASC";
$result = mysql_query($sql) or die (mysql_error());
//echo "<select name=\"\" id=\"\">";

echo "<form action=\"sum.php\" method=\"post\">";
echo "<select name=\"Test\">";  //ADDED
while ($row = mysql_fetch_array($result)){
   extract ($row);
  echo "<option value=\"$id\" OnChange=\"submit();\" > $name - $cmd - $StartDate - $t_letter_code_ef </option>";
}//Ends while
echo "</select>";
echo "<br>";
echo "<br>";
echo "<input type=\"submit\">";
echo "</form>";
echo "<br>";
echo "<br>";

[karol65]

Thanks.