radio button no effect

[gabrielkolbe]

Hi I have this code which ecco's out lines form entries in the db. I have posted here before but now the code has changed....

If you look at the code you will see the

 $_REQUEST['select']	= $prop_ID ;

this is set to a session

$_SESSION['prop_ID'] = $prop_ID;

when i echo this session i get the first entry in the db no matter which one i select with the radio button .....

Why??? Can anyone help??

echo ('
 <form action="newpage.php" method="post">
 <table width="537"  cellpadding="1"  cellspacing="0">
 <tr bordercolor="#FFFFFF">
 <td  ></td>
 <td ></td>
 <td  </td>
 <td ></td>
 <td  ></td>
 <td  ></td>
 <td> </td>
 </tr>
');

$color1 = "#CCFFCC"; 
$color2 = "#BFD8BC"; 
$row_count = 0;

$query = "SELECT * FROM right_prop_1 WHERE username = '".$_SESSION['user_logged']."'";

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

while ($row = mysql_fetch_array($result)) { 
 $prop_ID = $row['prop_ID']; 
 $sale = $row['sale']; 
 $price = $row['price'];
 $number = $row['number'];
 $street = $row['street'];
 $city = $row['city'];

$row_color = ($row_count % 2) ? $color1 : $color2;

echo ('
 <td class="menu_names" bgcolor="'.$row_color.'">
 <input type="radio" name="select" value="'.$row['prop_ID'].'"></td> 
 <td class="menu_names" bgcolor="'.$row_color.'">'.$prop_ID.'</td> 
 <td class="menu_names" bgcolor="'.$row_color.'">'.$sale.'</td> 
 <td class="menu_names" bgcolor="'.$row_color.'">'.$price.'</td>
 <td class="menu_names" bgcolor="'.$row_color.'">'.$number.'</td>
 <td class="menu_names" bgcolor="'.$row_color.'">'.$street.'</td>
 <td class="menu_names" bgcolor="'.$row_color.'">'.$city.'</td></tr>
');  

$row_count++;

$_REQUEST['select']	= $prop_ID ;
$_SESSION['prop_ID'] = $prop_ID;



}
echo ('
 </table>
 </form>
');

[devinemke]

you have it backwards, you want...

$prop_ID = $_REQUEST['select'];

instead of...

$_REQUEST['select'] = $prop_ID;

[gabrielkolbe]

Thanks I have changed it but it still gives the same problem.....

[gabrielkolbe]

Thanks but still gives the same problem...

[yinrunning]

Why do you need $prop_id ? Why not

$SESSION['prop_ID'] = $REQUEST['select']; (Not sure which order you wanted those.)

Keep in mind that that is read "Set the value of Session prop_ID equal to the value of whatever's in Request's select". (I know that's a "duh", but I've made that mistake way too many times.) What you were doing before (in the full code you pasted) was setting both of them to the value of $prop_id BEFORE prop_id was set to the value of either one of them.

So, if Request was set to Bob, Session was null, and prop_id was set to Janie,

you wanted Session set to Bob.

Instead, you set Session and Request to Janie. My question is, who needs Janie? I mean, I know she's hot and all, but c'mon now!

Sorry to belabor that. Just wanted to be crystal clear. If that doesn't solve the problem, you probably need to revisit the data flow and do a test to insure that the variable you want from the radio button is actually being passed AND that you're actually recieving it correctly. Debugging is a b@#$%, ain't it? 😃

Good Luck!!

[gabrielkolbe]

Thanks for your help yin running BUt the problem still persist...

the problem is the $REQUEST['select'] doesn't get the value from the radio button script....

thanks any way, and yes debugging is a b#$%^h

[leatherback]

Hi,

In your query, you do not use the radiobutton. So of course you are not getting the record you want to select.

You now have:

$query = "SELECT * FROM right_prop_1 WHERE username = '".$_SESSION['user_logged']."'";

which should be like:

$query = "SELECT * FROM right_prop_1 WHERE username = '".$SESSION['user_logged']."' and prop_ID = $REQUEST['select']";

[gabrielkolbe]

Thanks for you advice. But I think you are wrong. The sql statement is first then the line is echo- ed out then it is selected NOT the other way round.....

[leatherback]

OK, be clear.. WHAT is the exact problem?
The query as it stands, will retuyrn ALL records where the username is equal to the current username, without further subsetting it to the selected radiobutton..

J.

[yinrunning]

Yeah, I'm confused as well, because I just actually read all the code there.

What exactly are you trying to do with the $REQUEST['select']= part? Because your form is passing the radio information to newpage.php. That's the page in which you retrieve the $REQUEST[] data. Why exactly are you trying to set it here? That data can't be set by php before the user sees the form.

According to the code I can see, what you're trying to do is:

• php spits out an html form, with values passed from query.
• user clicks form, IN the browser (no php control there).
• http passes values to newpage.php inside $_REQUEST array.
• then, on newpage, php would get data and parse it.

Right?