php radio button question

jabfinger · 08-13-2005, 11:56 PM

I have this code:

Code:

<?php
echo "<form method=\"post\" action=\"roster_process.php\" name=\"roster\">";
require_once "DB.php";
require_once "footballdb.php";
$conn =& DB::connect (fantasydb_dsn ());
if (DB::isError ($conn))
die ("Cannot connect to server");

$query1 ="CREATE TEMPORARY TABLE temp SELECT 
DISTINCT CONCAT(qb_stats.first_name,\" \",qb_stats.last_name) AS qb_name FROM qb_stats";
$result = mysql_query($query1) or die ("Query for qbtemp");
$query = "SELECT temp.qb_name FROM temp,members WHERE members.name=temp.qb_name 
AND members.owner=\"$owner\"";
$result = mysql_query($query) or die ("Query for QB");

//let's get the number of rows in our result so we can use it in a for loop
$numofrows = mysql_num_rows($result);
for($i = 0; $i < $numofrows; $i++) 
{
$row = mysql_fetch_array($result); //get a row from our result set
echo "<FONT SIZE=\"2\"><input name=\"qb_group\" 
value=".$row[0]." type=\"radio\">&nbsp;".$row[0]."</FONT><br>";
}
//now let's close the table and be done with it
"DROP TABLE temp";
$conn->disconnect ();

echo  "<input name=\"submit\" value=\"Enter\" type=\"submit\"></div>
</form>";
?>

Which is supposed to place qb_name's(first and last) next to radio buttons in a form. It is also supposed to send the selected qb_name(first and last) to another page (roster_process.php) when the Enter button is pressed.

The code for roster_process.php is this:

Code:

<html>
<head>
<body>
<?php
$qb_group = $_POST["qb_group"];
echo "$qb_group<br>";
?>
</body>
</head>
</html>

what happens is, on the form next to the radio buttons the first and last names of the desired qb's appear however on the roster_process.php page only the first name appears.

What is prohibiting both the first and last name of qb_name from being displayed on the roster_process.php page. I hope I have given enough detail about this problem for someone to be able to see the problem. The more I try to figure this out the less I understand.

Thanks.

keefaz · 08-14-2005, 05:54 AM

In the first code, change :

PHP Code:



... 
echo "<FONT SIZE=\"2\"><input name=\"qb_group\"  
value=".$row[0]." type=\"radio\"> ".$row[0]."</FONT><br>"; 
...

to :

PHP Code:



... 
echo "<FONT SIZE=\"2\"><input name=\"qb_group[]\"  
value=".$row[0]." type=\"radio\"> ".$row[0]."</FONT><br>"; 
...

And in roster_process.php, change :

PHP Code:



... 
echo "$qb_group<br>"; 
...

to :

PHP Code:



... 
foreach($qb_group as $group) echo "$group<br>"; 
...

david_ross · 08-14-2005, 07:04 AM

If you want to select multiple values then you'll need to use checkboxes instead of radio buttons as well as making the changes keefaz mentioned above.

jabfinger · 08-14-2005, 09:26 AM

Thanks guys, for the reply.

Keefaz,

I corrected the code as you instructed but I get the same results, "first_name" only for the
roster_process.php page and "first_name last_name" for the originating roster.php page. I can not understatd this. It seems to me that ".$row[0]." should contain the exact same data for both instances.

david_ross · 08-14-2005, 09:52 AM

I think I see what you are meaning now. You need to escape the value in quotes - change:
value=".$row[0]."
to:

value=\"".$row[0]."\"

jabfinger · 08-14-2005, 10:36 AM

thanks again for the reply,

david_ross,

You fixed it.

It works as should. I am now confused by the fact that the old code placed the first_name on the roster_process.php page. Why did it place anything there at all? The code as it is now has two sets of .$row[0]. one with double quotes(escaped) and one with single quotes. They dont act the same way. If I place double quotes(escaped) on both, I end up with quotes around the name on the originating page but not on the roster_process page.

Anyway thanks for fixing this for me and if you have the time mabey you could clear up my question as well.