radio buttos+mysql

scotte

I have radio buttons that are to display a price, but i have sets of them (dif names)

i want the same page to call up the DB and get the price depending onthe radio button they choose. Is there a way to do this by using an update button, but so that the page with the radio buttons shows the price not the process.php page!

<form action="??" method="post">

<input name="1" type="radio" value="2"><br>
<input name="1" type="radio" value="2" ><br>
<input name="1" type="radio" value="3" ><br><br>

<input name="2" type="radio" value="1"><br>
<input name="2" type="radio" value="2"><br>
<input name="2" type="radio" value="3"><br><br>
<input name="Submit" type="button" value="submit">
  </p>
</form>

I am real new to mysql, any help appreciated. I can process it on a diff page but not on the same!

dnast

You can use

if (isset($_POST['Submit'])) {
    //code to show price and whatever else
    exit;
}
else {
    //display form
}

scotte

Not sure how to intergrate what you have told me above.

This is where i am at now

<body>
<?php

$query = SELECT `product_price` From `products` WHERE `product_id` = ('".$_POST['wow']."');

<form action="$query" method="post">

<input name="1" type="radio" value="2" name="wow"><br>
<input name="1" type="radio" value="2" name="wow"><br>
<input name="1" type="radio" value="3" name="wow"><br><br>

<input name="2" type="radio" value="1" name="wow"><br>
<input name="2" type="radio" value="2" name="wow"><br>
<input name="2" type="radio" value="3" name="wow"><br><br>
<input name="Submit" type="button" value="submit">
  </p>

?>
</body>

I am tryign to get the datbase stuff to display on the page, not so sure how to get this done!

Please, any help apprecciated!

Scott

dnast

<body>
<?php
if (isset($_POST['Submit'])) { //do this code only after a submit
    $query = SELECT `product_price` From `products` WHERE `product_id` = ('".$_POST['wow']."');
    $result = mysql_query($query)
        or die (mysql_error());
    echo $result['product_price']; //displays the price
    //other code to display cost info
    exit; //only if you don't want the form to display after a submit
}
else { //display the form if submit button was not pressed
?>
<form action="$query" method="post">

<input name="1" type="radio" value="2" name="wow"><br>
<input name="1" type="radio" value="2" name="wow"><br>
<input name="1" type="radio" value="3" name="wow"><br><br>

<input name="2" type="radio" value="1" name="wow"><br>
<input name="2" type="radio" value="2" name="wow"><br>
<input name="2" type="radio" value="3" name="wow"><br><br>
<input name="Submit" type="button" value="submit">
  </p>
<?php
} //end of 'else'
?>
</body>

scotte

Thankyou so much, i need to take a course on php, will do when i finish school. No of any good ones?

dnast

Not really. 🙁 I found these forums and the php manual useful enough. 🙂

Also, please ignore the "exit;" part. I'm not sure why I put that in there. It's not necessary.