Pass Value of Radio Buttons through SQL Query

[chavad]

Dear Everyone,

I am very new to both PHP and MySQL. I have a MySQL database that includes a field called "max_rooms" with the values 1 or 2 set for each row in the database it applies to. In my HTML document, I have a form containing a question named "max_rooms" with two choices that are radio buttons. My PHP and MySQL are connected properly; I just don't know what to write in the form results PHP document so that the values are passed correctly. I think it might be something like the following, but I'm not sure and anyway don't know what to do after that:

$sqlquery = "SELECT * FROM hallonly";
$sqlquery .=" where max_rooms = $_POST['max_rooms']";

Thanks!!
Chava

[sunfighter]

Your form with radio buttons:

<form name="myForm" action="test.php" method="post">
<h4>Enter Max Number of Rooms.</h4>
<input type="radio" name="rooms" value="1" /> : 1 Room<br />
<input type="radio" name="rooms" value="2" /> : 2 Rooms<br />
<input type="submit" value="Submit">
</form>

Calls this php file "test.php":

PHP Code:

<?php
echo $_POST["rooms"];
?>

So if your form is correct [the one I showed you] your php is correct.

[chavad]

Dear sunfighter,

Thanks much; I finally figured it out.

Chava