I want two fields to display on a listbox

[tjbarr]

Here is the code I have now:

     <select name="cboind[]" size="8" multiple class="listbox">

<?php

/
Create your SQL statement
/

$sql="SELECT naics, define from tbl_ind Where level=2 order by naics;";
$result_set = pg_Exec ($conn, $sql);
$rows = pg_NumRows($result_set);

if ((!$result_set) || ($rows < 1)) {
//No connection or no rows returned, so print an error
echo "<H1>ERROR - no rows returned</H1><P>";
exit; //exit the script
}

for ($j=0; $j < $rows; $j++) {
echo "<option value=".pg_result($result_set, $j, "naics")."> ".pg_result($result_set, $j,"define")."</option>";
} }

I would like both naics and define to show up on my page. what is the syntax?

[bpat1434]

It may be smarter to take the following approach:

<?php

/*
Create your SQL statement
*/

$sql="SELECT naics, define from tbl_ind Where level=2 order by naics;";
$result_set = pg_Exec ($conn, $sql);
$rows = pg_NumRows($result_set);

if ((!$result_set) || ($rows < 1)) {
//No connection or no rows returned, so print an error
echo "<H1>ERROR - no rows returned</H1><P>";
exit; //exit the script
}

echo '<select name="cboind[]" size="8" multiple class="listbox">';

while($row = pg_fetch_assoc($result_set)) {
  echo '<option value="' . $row['naics'] . '"> ' . $row['define'] . ' :: ' . $row['naics'] . '</option>';
}

echo '</select>';
}