***** IMPRESSIVE!
Code: Select all
<div id='column2'>
<h1>View the Status of an RMA</h1>
<br />
<form action="<?php echo $_SERVER['PHP_SELF']; ?>"
method="GET" enctype="multipart/form-data">
<?php
print '<select name="rma">'."\n";
print '<option value="none">Select RMA number</option>'."\n";
$rma_number = mysql_query('SELECT * FROM rma');while ($rma = mysql_fetch_array($rma_number, MYSQL_ASSOC)){
print '<option value="'.$rma['id'].'"';
if($record_data['ref_rma_id']==$rma['id']) print " selected=\"selected\" ";
print '>'.$rma['rma_number']."</option>\n";
}
print '</select>'."<br />\n";
?>
<br />
<input type="submit" value="Submit" />
</form>
<?php
$targetrma = $_GET['rma'];
$sql = "SELECT rma.id, status.id, filename, date, description FROM dropbox, rma, status WHERE dropbox.ref_status_id=status.id AND dropbox.ref_rma_id=rma.id AND rma.rma_number = '$targetrma'";
$filelist = @mysql_query($sql);
if (!$filelist) {
exit('Database error: ' . mysql_error());
}
?>
<br />
<br />
<p>The following files are stored in the database:</p>
<div align="center">
<table id="rmaview">
<tr>
<th>RMA Number</th>
<th>RMA Status</th>
<th>Filename</th>
<th>Date</th>
<th>Note</th>
<th>Unit Type</th>
</tr>
<?php
if (mysql_num_rows($filelist) > 0) {
while ($f = mysql_fetch_array($filelist)) {
?>
<tr>
<td>
<?php echo $f['rma_number']; ?>
</td>
<td>
<?php echo $f['status_name']; ?>
</td>
<td>
<a href="<?php echo $_SERVER['PHP_SELF']; ?>?action=view&id=<?php echo $f['id']; ?>"><?php echo $f['filename']; ?></a>
</td>
<td>
<?php echo $f['date']; ?>
</td>
<td>
<?php echo $f['description']; ?>
</td>
</tr>
<?php
}
} else {
?>
<tr><td>No Files!</td></tr>
<?php
}
?>
</table>
</div>