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:
<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:
<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