Radio Buttons with database interaction

[djwinder]

Hi everyone

I’m trying to build a member management page. I have users whose information is held temporarily in a table called memrequest until the admin confirms their details at which point their details are copied into the main members table. I have been trying to design a page on which the admin can view all the members in memrequest in a table and then click a radio button for either accepting them or not. I have been getting a t-string error where i am trying to generate the radio buttons. If anyone can help me resolve this it would be a great help but if anyone can suggest a better means of doing this all together please let me know 🙂

  

$rowid =0;  //used to initialise this var which could be used to ID specific radio buttons
  if (!isset($_POST['submit'])) //if they haven't pressed the submit button, then show the form

  {
     require ($_SERVER['DOCUMENT_ROOT']. '/includes/header.php');

?>

 <tr>
   <td width="780" colspan="4" border="1" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">  
     <?PHP

$query = "select * from memrequest";
	 $rs = mysql_query($query);	
         $list = "<table width=\"780\" colspan=\"4\" border=\"0\" cellpadding=\"2\" bgcolor=\"#FFFFFF\">";
	 $list .= "<tr><th>First Name</th>";
	 $list .= "<th>Last Name</tr>";
	 $list .= "<th>Confirm</tr>";
	 $list .= "<th>Deny</th></tr>";
while ( $row = mysql_fetch_array($rs))
{
	$rowid++;
	$list .= "<tr>";
	$list .= "<td>".$row["fname"]."</td>";	
	$list .= "<td>".$row["sname"]."</td>";
	$list .= "<td> <input type="radio" name=" ".$row["rowid"]." "value="confirm"></td>";   //this is the line generating the t-string error
	//$list .= ""<input type="radio" name="".$row["memid"]."" value="deny">"";    // will be altered to reflect the above line when its working
        $list .= "</tr>";

//need some code to catch multiple selections of both confirm and deny
}
$list .= "</table>";
echo ($list); 

    ?>
   </td> 
 </tr>

[bradgrafelman]

You have unescaped double quotes on the line where you output the INPUT entity. If you use double quotes as your string delimiter, they must be escaped when they appear inside the string (as in the TABLE entity a few lines prior).

[djwinder]

Thanks for the responce, I have tried escaping the double quotes in a few diffrent combinations however i continue to get errors. The code below produces the following error, can you see what is wrong?

Parse error: parse error, unexpected T_CHARACTER, expecting T_STRING or T_VARIABLE or T_NUM_STRING in memrequests.php on line 30

 $list .= "<td> <input type=\"radio\" name=\".$row[\"rowid\"]\" value=\"confirm\"></td>"; 

[Haddman]

Try this

$list .= "<td> <input type='radio' name='".$row['rowid']"' value='confirm'></td>";

[djwinder]

thanks for the help, its now giving this error

Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in memrequests.php on line 30

[bradgrafelman]

There's a missing period between the ending ']' of the array and the last string piece.