Quote:
<TABLE WIDTH=800 BORDER=0 CELLPADDING=0 CELLSPACING=0>
<TR>
<TD>
<IMG SRC="images/newheader_01.gif" WIDTH=275 HEIGHT=39 ALT=""></TD>
<TD ROWSPAN=4>
<IMG SRC="images/newheader_02.gif" WIDTH=8 HEIGHT=96 ALT=""></TD>
<TD ROWSPAN=3 background="images/newheader_03.gif" WIDTH=512 HEIGHT=87 ALT="">
<div align="right">
<form action="searchresults2.php" method="post">
<font color="#FFFFFF" size="-1"> Search by product name:</font>
<input name="searchtext" type="text" size="15" />
<input type="submit" name="submit" value="Search Products" />
</form>
<?php
$dbcnx = mysql_connect( '*******', '*******, '*******' );
//$db = db_connect( "*******", "*******", "*******", "*******" );
mysql_select_db(*******);
$sql = @mysql_query('Select productname, catid FROM atoz');
if (!$sql) {
die('<p>Error performing query collecting data from database' .mysql_error() .
'</p>');
}
echo('<form action="searchresults2.php" method=post>');
echo('<font color="#FFFFFF" size="-1"> Search A-Z:</font><select name="catid">');
while ( $row = mysql_fetch_array($sql) ) {
echo ('<option name="atoz" value="'.$row['catid'].'">'.$row['productname'].'</option>');
}
echo('</select>');
echo ('<input type="submit" name="submitatoz" value="Search" />');
echo ('</form>');
?>
</div>
</TD>
<TD ROWSPAN=2>
<IMG SRC="images/newheader_04.gif" WIDTH=5 HEIGHT=48 ALT=""></TD>
<TD>
<IMG SRC="images/spacer.gif" WIDTH=1 HEIGHT=39 ALT=""></TD>
</TR>
<TR>
<TD ROWSPAN=3>
<IMG SRC="images/newheader_05.gif" WIDTH=275 HEIGHT=57 ALT="">
</TD>
<TD>
<IMG SRC="images/spacer.gif" WIDTH=1 HEIGHT=9 ALT=""></TD>
</TR>
<TR>
<TD ROWSPAN=2>
<IMG SRC="images/newheader_06.gif" WIDTH=5 HEIGHT=48 ALT=""></TD>
<TD>
<IMG SRC="images/spacer.gif" WIDTH=1 HEIGHT=39 ALT=""></TD>
</TR>
<TR>
<TD>
<IMG SRC="images/newheader_07.gif" WIDTH=512 HEIGHT=9 ALT=""></TD>
<TD>
<IMG SRC="images/spacer.gif" WIDTH=1 HEIGHT=9 ALT=""></TD>
</TR>
</TABLE>