Hi all,

I need the expertise of you php/mysql gurus yet again.

I have a page that contains the following code

<snip>
<? session_start();
session_register ("source_table","destination_table")?>

</snip>

On the same page I have the following code to put up 2 select boxes

<snip>

// create SQL statement
 $sql = "SELECT *
   FROM tabnames ORDER BY table_id";

 // execute SQL query and get result
 $sql_result = mysql_query($sql,$db)
   or die("Couldn't execute query.");

 print "<select name='destination_table'>\n";
 while ($row = mysql_fetch_array ($sql_result)) {
   print "<option value='" . $row["system_name"];
  // print "<option value='" . $row["table_id"];
   print "'>" . $row["table_name"] . "</option>\n";
 }
 print "</select>\n";



?>
        <div align="center"></div></td>
      <td><?

// create SQL statement
 $sql = "SELECT *
   FROM operations ORDER BY op_id";

 // execute SQL query and get result
 $sql_result = mysql_query($sql,$db)
   or die("Couldn't execute query.");

 print "<select name='op_id'>\n";
 while ($row = mysql_fetch_array ($sql_result)) {
   print "<option value='" . $row["op_id"];
   print "'>" . $row["operation"] . "</option>\n";
 }
 print "</select>\n";



____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com
       Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
    http://wdvl.internet.com/WDVL/Forum/#sub

________________  http://www.wdvl.com  _______________________

You are currently subscribed to wdvltalk as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]

Reply via email to