Problem using radio buttons to select

jeremycd

I am trying to use radio buttons to select a certain row in a table... the thing is the table and the radio buttons are generated automatically so i dont konw how to label the radio button so i can call it in a mySQL query...

function getData ($table,$PHP_SELF)
{
	?><form method="post" action="<?=$PHP_SELF ?>?action=process"><?
    $query = "SELECT * FROM ".$table;
    $result = mysql_query($query); 
    // for every row
    while ($row = mysql_fetch_assoc($result))
    {

    echo "<tr>";
   //Start the radio button THIS IS WHERE I THINK THE PROBLEM LIES
    ?><td><input type=radio name=eventSelect value="THIS IS WHERE I AM STUCK"></td> <?
    // for every field
    foreach ($row as $key => $value)
    {
    	//add the fields from the db into rows
        echo "<td>".$value."</td>";

    }
    echo "</tr>"; 
}
echo "</table>";
 ?><input type=submit value = "View Details"><?
 ?></form><?

}

any help would be great

thanks

Jeremy

dfr574

Wouldn't you use the same value you are using for $value, but include it within your foreach loop?

        foreach ($row as $key => $value)
        {
echo "<input type=radio name=eventSelect value=\"$value\"></td>\n";
echo "<td>".$value."</td>";

    }

then:

sql = "SELECT details FROM tbl WHERE row = '".$_POST['eventSelect']."'";