problem with radio button

[mrjameer]

hi,

i have a table.it's structure is like this
itemno--itemname--price
1--abc--200
2--djh--300
3--eee-400

i want to dynamically create 3 radio buttons for prices and to display these records on web page and when a user click radio button of any one the selected values should be stored in some other table.how to do this.i know how to display and store in db.problem is with dynamically creating radio buttons.please any of your help is appreciated.

thanks
mrjameer

[.josh]

[code]
// example retrieval of all info in your db

$sql = "select * from table";
$result = mysql_query($sql) or die(mysql_error());

while ($list = mysql_fetch_array($result)) {
  // make a radio button with the item name next to it. radio button will
  // pass all of the info associated with the item as an array called [itemname]
  echo "<input type='radio' name='{$list['itemno']}' value='{$list}'>{$list['itemname']}<br/>";
}
[/code]

[simcoweb]

Please post your code you have now for summoning and displaying your products :)

[JP128]

[code]
<?php
//Connect to DB here
$sql = mysql_query(\"SELECT * FROM `tablename`\");
?>
<form method=\"PAGE HERE\" action=\"\">
<?php
while($row = mysql_fetch_assoc($sql)){
echo\"<input type=\'radio\' value=\".$row[\'price\'].\" name=\'\".$row[\'itemno\'].\"\'>\".$row[\'itemname\'];
}
?>
</form>
<?php
//Of course, you will need to change some of the information, but that is the basic structure.
?>
[/code]

[JP128]

ok, i dont know what happened with all of those escape slashes, but they shouldn\'t be there.