[Resolved] self populating list box

[stsintzo]

Hi, can anyone point me to php code that will connect to a MySQl db table and populate a list box/menu ?

[dartcol]

There are loads of postings on connecting to a database.

As for the PHP I had a similar problem myself a while back.
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10237549

MySQL query
	while ($row = mysql_fetch_row($result)) {
  		for ($i = 0; $i < mysql_num_fields($result); $i++) {
			printf ("<option>%s</option>\n", ($row[$i]));
		}
	}

Put it between the <select name=""></select> tags and it should bring up the data from the selected column

[Gary_King]

Try this:

$connect=mysql_connect("localhost","","");
$db=mysql_select_db("database",$connect);

$query=mysql_query("SELECT col_name FROM tbl_name");
print "<select name='name'>";
while ($row = mysql_fetch_row($query)) {
	for ($i = 0; $i < mysql_num_fields($query); $i++) {
  	printf ("<option>%s</option>\n", ($row[$i]));
  }
}
print "</select>";

That will work.

[dartcol]

It can be easier to debug if you split the query too.

$sql = "SELECT ...";
$result = "mysql_query($sql)";
if (!$result) {
	echo("<p>Error performing query: " .
		mysql_error() . "</p>\n");
	exit();

Then the <SELECT>. Either way will work.

[Gary_King]

You will get a parse error like that.

This will work instead:

<?php

$connect=mysql_connect("localhost","","");
$db=mysql_select_db("database",$connect);

$query=mysql_query("SELECT col_name FROM tbl_name");

if (!$query) {
    print "<p>Error performing query: ".mysql_error() . "</p>\n";
    exit();
}

print "<select name='name'>";
while ($row = mysql_fetch_row($query)) {
    for ($i = 0; $i < mysql_num_fields($query); $i++) {
      printf ("<option>%s</option>\n", ($row[$i]));
  }
}
print "</select>";

?>

[dartcol]

Thanks Gary W. I stand corrected. Must get myself a strong cup of coffee.

[Gary_King]

Originally posted by dartcol
Thanks Gary W. I stand corrected. Must get myself a strong cup of coffee.

No problem. I think I need one as well, getting a little drowsy here. I can barely stay awake.

[stsintzo]

The scripts worked perfectly, thanks again everyone. 🙂