[thelist] Query selected

Andrew andrew at humanbehaviour.co.uk
Tue Mar 4 09:12:01 CST 2003

Hi Rich it doing things differently now :)  just needs a final tweak if you can
spot what it is that would be great.  It isn't diplaying what was previously
selected but it is working!  I've tried all the combination except the right one

Actually as a matter of interest this function method?  Is it efficient to use
this method for a drop down as opposed to running the query from the same file?

function CategoryDDmenu($selected=0)
$Query = "SELECT City, CityID FROM city ORDER BY City";
$Result = mysql_query($Query);
    if(mysql_num_rows($Result) <= 0){ print "NO RESULTS FOUND!"; }
    else {
        print "<select name=\"CityID\">\n";
        if($selected == 0){
            print "<option value=\"City\" selected> -- SELECT AN OPTION --
        while($RowData = mysql_fetch_array($Result)){
            print "<option value=\"" . $RowData['CityID'] . "\"";
            if($selected == $RowData['CityID']){ print " selected"; }
            print ">" . $RowData['City'] . "</option>\n";
        }//END while
        print "</select>\n";
} else {
}//END if
}//END function CategoryDDmenu


More information about the thelist mailing list