msql loop..

[ristenk1]

Hi, I want to create a loop that reads out each of my page's menu_name from the database and on the same line that it reads it out, put a radio button to change the visibility. So far It looks like my radio buttons are on a different line and are all connected (instead of being checked "no" for all of them it is only check no on the last one of the entire sequence...

    //K's function:        function get_all_pages() {        global $connection;        $query = "SELECT *                 FROM pages ";        $query .= "WHERE visible = 1 ";        $query .= "ORDER BY position ASC";        $page_set = mysql_query($query, $connection);        confirm_query($page_set);        return $page_set;    }        //K's function:function list_all_pages(){$output = "<ul>";$page_set = get_all_pages();while ($page = mysql_fetch_array($page_set)) {$output .= "<li><a href=\"add_feature.php?page=" . urlencode($page["id"]) . "\">{$page["menu_name"]}</a></li>";$output .= "&nbsp;&nbsp;<input type=\"radio\" name=\"visible\" value=\"0\" checked=\"checked\" /> No <input type=\"radio\" name=\"visible\" value=\"1\" /> Yes";    }$output .= "</ul>";return $output;} 

pic1.jpg

[ristenk1]

Posting code again as the previous is hard to read:

//K's function:
function get_all_pages() {
global $connection;
$query = "SELECT *
FROM pages ";
$query .= "WHERE visible = 1 ";
$query .= "ORDER BY position ASC";
$page_set = mysql_query($query, $connection);
confirm_query($page_set);
return $page_set;
}

//K's function:
function list_all_pages(){
$output = "<ul>";
$page_set = get_all_pages();
while ($page = mysql_fetch_array($page_set)) {
$output .= "<li><a href=\"add_feature.php?page=" . urlencode($page["id"]) . "\">{$page["menu_name"]}</a></li>";
$output .= "&nbsp;&nbsp;<input type=\"radio\" name=\"visible\" value=\"0\" checked=\"checked\" /> No <input type=\"radio\" name=\"visible\" value=\"1\" /> Yes";
}
$output .= "</ul>";
return $output;
}

Picture can be clicked on to enlarge and see what I am talking about

[ristenk1]

ok, I think the answer is that my radio buttons had the same "name" attribute.. giving that a shot

[DaveSawers]

Yes, changing the names should fix it.

Why not use a check box for this function though?

[Tom]

Yes, the problem is the radio names. You could add a unique ID number onto the end of the names which is also stored in the database so that the names are unique.