dynamic dropdown not work

sarmenhb · 02-17-2008, 04:37 AM

heres the function im using

when i load the page the drop down doesnt show anything. so im wondering if there is a syntax error u can find because my ide isnt finding any.

this is how im typing the html out

<select><?php dyn_dropdown(tbl_status,status); ?></select>

Code:

function dyn_dropdown($tablename,$columnname) {


	$query = mysql_query("SELECT $columnname FROM $tablename");
	
	if(mysql_num_rows($query))
	{
	while($row = mysql_fetch_assoc($query))
	{
	$block = "<option>";
	$block .=  $row['$columnname'];
	$block .= "</option>";

	}
	
	}
	else {
	echo "<option>no data</option>";
	}

}

here is the table structure

tbl_status

Code:

CREATE TABLE `tbl_status` (
  `id`      int AUTO_INCREMENT NOT NULL,
  `status`  varchar(20) NOT NULL,
  /* Keys */
  PRIMARY KEY (`id`)
) ENGINE = InnoDB;

heres the data it contains

Code:

        id status                                                       
        20 open                                                         
        21 op