Dynamic Population Of List Box

[schowhan]

Hi All,

I am trying to populate a list box dynamically from a table in MySql Database. I wrote some code but it's populating the list box with empty strings. Please help me in this regard.

<?
function drop_down ($table = "", $value_field="", $label_field="", $sort_field="", $where="")
{
$values = array();
if (empty($table) || empty($value_field)) { return $values; }
if (empty($label_field)) { $label_field = $value_field; }
if (empty($sort_field)) { $sort_field = $label_field; }
if (empty($where)) { $where = "1=1"; }
global $getrows;

$query = "select $value_field as value_field, $label_field as label_field from $table where $where order by $sort_field";

echo (" func query - $query <br>");
$result = mysql_query($query);
$getrows = mysql_num_rows($result);
echo ("func getrows - $getrows");
if ($result)
{
while (list($value, $label) = mysql_fetch_array($result))
{
$values[$value] = $label;
}
}
return $values;
}

$test_values = array();
$test_values = drop_down ("REPORT_RESULTS", "ID");
echo ("getrows outside func - $getrows");
echo (" <td> <select name=\"Incident_Type2\"> ");
echo (" <option selected value=\"\">Null</option> ");
for ($i=1;$i<=$getrows;$i++)
{
echo (" <option value=\"{$test_values[i-1]}\">{$test_values[i-1]}</option> ");
}
echo (" </select> ");
echo (" </td> ");

echo (" <tr> ");
echo (" <td> ");
echo (" <p>&nbsp;</p> ");
echo (" <p><font face=\"Arial, Helvetica, sans-serif\" size=\"2\" color=\"#666666\"><b>Search Details:</b></font></p> ");

?>

Thanks in advance,

shankar

[Anon]

Shouldn't you be using $i insted of just i inside your for loop? The line with the option echo. What are the {}s for?

[schowhan]

Thanks for that but still I am not getting it. I modified the code, help me

<?php
if(!isset($query) || empty($query))
{
$query = "select * from REPORT_RESULTS";
}
//global $where;
include ('Build_Where.php');
echo "where-" . $where;

if (!empty($where))
{ $query = $query . " where " . $where ; }

$query = stripslashes($query);

// "Connect To Database";
include('connect_button.php');

// "Getting Number of Total Rows";
$numresults = mysql_query($query) or die(mysql_error());
$numrows = mysql_num_rows($numresults);
// echo "<b>TotalRows: $numrows</b>\n";
$number_cols = mysql_num_fields($numresults);

$limit=15; // rows to return
// next determine if offset has been passed to script, if not use 0
if (empty($offset)) {
$offset=0;
}

$limit_string = " limit ". $offset. "," .$limit;
$query = $query . $limit_string;
$query = stripslashes($query);
$result = mysql_query($query) or die(mysql_error());

// echo "<b>query:$query</b>";
//Table Body
echo "<table border = 1>\n";

echo "<TR bgColor=#999999>";
//print "<a href=\"$PHP_SELF?offset=$prevoffset\">PREV</a>&nbsp;\n";
//echo "<a href=\"calldetails.htm\" >";
//echo $row[$i];
//echo "</a>\n";
echo "<TD>";
echo "<DIV align=center><B><FONT face=\"Arial, Helvetica, sans-serif\" size=2><a href=\"$PHP_SELF?orderby= ID DESC\">Number</a></FONT></B></DIV>";
echo "$query";
echo "</TD>";

      echo "<TD>";
       echo "<DIV align=center><B><FONT face=\"Arial, Helvetica, sans-serif\" size=2>Siebel No.</FONT></B></DIV>";
      echo "</TD>";

      echo "<TD>";
       echo "<DIV align=center><B><FONT face=\"Arial, Helvetica, sans-serif\" size=2>Start Date</FONT></B></DIV>";
      echo "</TD>";

      echo "<TD>";
       echo "<DIV align=center><B><FONT face=\"Arial, Helvetica, sans-serif\" size=2>End Date</FONT></B></DIV>";
      echo "</TD>";

      echo "<TD>";
       echo "<DIV align=center><B><FONT face=\"Arial, Helvetica, sans-serif\" size=2>IDC</FONT></B></DIV>";
      echo "</TD>";

      echo "<TD>";
       echo "<DIV align=center><B><FONT face=\"Arial, Helvetica, sans-serif\" size=2>Plat Form</FONT></B></DIV>";
      echo "</TD>";

      echo "<TD>";
       echo "<DIV align=center><B><FONT face=\"Arial, Helvetica, sans-serif\" size=2>Type</FONT></B></DIV>";
      echo "</TD>";

      echo "<TD>";
       echo "<DIV align=center><B><FONT face=\"Arial, Helvetica, sans-serif\" size=2>Resolution</FONT></B></DIV>";
      echo "</TD>";

echo "</TR>";

while ($row = mysql_fetch_row($result))
{
echo "<tr align=left>\n";

for ($i=0; $i<$number_cols; $i++)
{
echo "<td>";
$color = "#000000";
if ($i == 1)
{
if ($row[$i] > 500)
{$color = "#FF0000";
#echo("<A HREF="premiumcare.htm\">" \"refresh page\" </A>");
}
else
{$color = "#336633";}
}

 echo "<div align=\"center\"><font color = $color size=\"2\" face=\"Arial, Helvetica, sans-serif\">";

 if (!isset($row[$i]))
   {echo "NULL";}
 else
   { echo $row[$i];
     #echo "<a href=\"calldetails.htm\" >";
     #echo $row[$i];
     #echo "</a>\n";
   }
 echo "</font></div>";
 echo "</td>\n";
}

echo "</tr>\n";
}

echo"</table>\n";

// next we need to do the links to other results

//if ($offset==1) { // bypass PREV link if offset is 0
// $prevoffset=$offset-15;
// print "<a href=\"$PHP_SELF?offset=$prevoffset\">PREV</a> &nbsp; \n";
//}

// If page 1, then don't show PREV
if ($offset >= 1) {
$prevoffset = $offset - 15;
print "<a href=\"$PHP_SELF?offset=$prevoffset\">PREV</a>&nbsp;\n";
}

// calculate number of pages needing links
$pages=intval($numrows/$limit);

//if ($pages < ($numrows/$limit)){
//$pages=((intval($numrows/$limit)) + 1);
//}

// $pages now contains int of pages needed unless there is a remainder from division
if ($numrows%$limit) {
// has remainder so add one page
$pages++;
}

// I made this change so if the current
// page was displayed it wouldn't create
// a link
for ($i=1;$i<=$pages;$i++)
{ // loop thru
$newoffset=$limit*($i-1);
if ($newoffset == $offset)
{ print "$i&nbsp;\n"; }
else
{ print "<a href=\"$PHP_SELF?offset=$newoffset\">$i</a>&nbsp;\n"; }
}

if (! (($offset/$limit) == ($pages - 1) ) && ($pages != 1) )
{

$newoffset = $offset+$limit;
print "<a href=\"$PHP_SELF?offset=$newoffset\">NEXT</a><p>\n";
}

function drop_down_3 ($table = "", $value_field="", $label_field="", $sort_field="", $where="")
{

$values = array();
if (empty($table) || empty($value_field)) { return $values; }
if (empty($label_field)) { $label_field = $value_field; }
if (empty($sort_field)) { $sort_field = $label_field; }
if (empty($where)) { $where = "1=1"; }
global $getrows;

$query = "select $value_field as value_field from $table where $where order by $sort_field limit 20";
//echo (" func query - $query <br>");
$result = mysql_query($query);
//echo ("func result - $result");
$getrows = mysql_num_rows($result);
//echo ("func getrows - $getrows <BR>\n");
if ($result)
{ while ($pullrows = mysql_fetch_array($result, MYSQL_ASSOC))
//echo "pull rows-". $pullrows ["value_field"] . "<BR>\n";
{
while (list($key, $value) = each($pullrows))
{
//echo "value = $value - key = $key <BR>\n";
$values[$key] = $value;
echo "$key - $values[$key] <BR>\n";
}
}
}
echo "2$key - $values[$key] <BR>\n";
return $values;
}

$test_values = array();
$test_values = drop_down_3 ("REPORT_RESULTS", "ID");
$checked_count = count($test_values);
echo "checked_count-" . $checked_count;
echo ("func getrows outside loop - $getrows");
echo (" <td> <select name=\"Incident_Type2\"> ");
echo (" <option selected value=\"\">Null</option> ");
for ($i=1;$i<=$getrows;$i++)
{
//echo (" <option value=\"{$test_values[$i][$i-1]}\">{$test_values[$i][$i-1]}</option> ");
//echo (" <option value=\"{$test_values[$i]}\">{$test_values[$i]}</option> ");
echo (" <option value=\"{$test_values["value_field"]}\">{$test_values["value_field"]}</option> ");
}
echo (" </select> ");
echo (" </td> ");

?>