Re: Help With Inventory
| From: | Jim Lucas | Date: | Mon, 22 Jan 2007 16:38:26 +0000 |
| Subject: | Re: Help With Inventory | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-247552@lists.php.net to get a copy of this message | ||
Here is my rendition of your script. Give it a shot...
Let me know if you have any question about what is going on.
I was curious, what is the point of having the alternating column colors? Was that your intention?
<?php
function invlistONE(){
dbconnect('connect');
$invlist = mysql_query("SELECT * FROM sp_dvd
ORDER BY dvdGenre");
echo <<<HEREDOC
<style type="text/css">
.dvdDisplay th {
font-size: 9pt;
text-align: left;
}
.dvdDisplay td {
font-size: 8pt;
}
</style>
<table cellspacing="0" id='dvdDisplay">
<thead>
<tr>
<th width="20" class="body">DVD ID</th>
<th width="225">TITLE</th>
<th width="75" class="body">GENRE 1</th>
<th width="75">GENRE 2</th>
<th width="75" class="body">GENRE 3</th>
<th width="10">ACT</th>
<th width="10" class="body">QTY</th>
<th width="10">BCK</b></th>
<th width="10" class="body">HLD</th>
<th width="10">INC</b></th>
<th width="50" class="body">OG USR</th>
<th width="30">OUT DATE</th>
<th width="55" class="body">OUT USR</th>
<th width="30">IN DATE</th>
<th width="50" class="body">IN USR</th>
<th width="10">CY</th>
</tr>
</thead>
<tbody>
HEREDOC;
$count = 0;
while ( $row = mysql_fetch_array( $invlist ) ) {
if ( $count % 1 ) {
$rowColor = '#c1c1c1';
} else {
$rowColor = '';
}
echo <<<HEREDOC
<tr bgcolor="{$rowColor}">
<td class='body'>{$row['dvdId']</td>
<td>{$row['dvdTitle']}</td>
<td class='body'>{$row['dvdGenre']}</td>
<td>{$row['dvdGenre2']}</td>
<td class='body'>{$row['dvdGenre3']}</td>
<td>{$row['dvdActive']}</td>
<td class='body'>{$row['dvdOnHand']}</td>
<td>{$row['backordered']}</td>
<td class='body'>{$row['dvdHoldRequests']}</td>
<td>{$row['incomingInverntory']}</td>
<td class='body'>{$row['ogUserId']}</td>
<td>{$row['outDate']}</td>
<td class='body'>{$row['outUserId']}</td>
<td>{$row['inDate']}</td>
<td class='body'>{$row['inUserId']}</td>
<td>{$row['cycles']}</td>
</tr>
HEREDOC;
$count++;
echo '</tbody></table>';
}
}
?>