script ok in IE & Opera - error in netscape

Mike Rambo mrambo@lsd.k12.mi.us
Fri, 29 Dec 2000 15:12:59 -0500


Edward Glowacki wrote:
> 
> 
> Maybe you could include the HTML generated
> by this script where you are having the error?

Here's the form context:

<equipment.php>

<?php //equipment.php
  $table_name = 'equipment';
  require('staff_common.inc');
  affy_header("Record Maintenance: $table_name");
?>

<h1>
  Record Maintenance:&nbsp;
  <font color="green">
   <?php echo $table_name; ?>
  </font>
</h1>

<?php
  require($table_name .'_query_form.inc'); <==Call the form
//  $query_sn=123;  <==Where I experimentally assign a value

  $query_sql="
    select
      *
    from $table_name
    where serial_nmbr=$query_sn
  ";
  $result=
    mysql_db_query($dbname,$query_sql,$id_link);
  if(!result) {
    affy_error_exit('SQL Select Execution has failed.');
  }
  $number_of_rows = @mysql_num_rows($result);
  if ($number_of_rows < 1) {
    echo '<p>There are no records in this table.</p>';
  }
  else {
    echo "<p>There are $number_of_rows records</p>";
  }
?>

<ul>
<table border="1" cellpadding="3" cellspacing="0">
  <?php
  require($table_name . '_dsp_1_rec_hdr.inc');

  {
  $record = mysql_fetch_object($result);
  require($table_name . '_dsp_1_rec.inc');
  }

  ?>
</table>
</ul>

<?php    
  affy_footer();
?>

</equipment.php>


<equipment_query_form.inc>

<form action="<?php echo $php_self ?>" method="post">
  <input type="hidden" name="action" value="insert">
  Serial Number:&nbsp;
  <input type="text" name="query_sn" size=31 maxlength=30>
  <input type="submit" value="Query">
</form>

</equipment_query_form.inc>

I've just started playing with this so it certainly isn't complete, or
even really functional, and has a few lines I've used as diagnostic
tools along the way.  My concern now is the failure with netscape.


-- 
Mike Rambo
mrambo@lsd.k12.mi.us