Re: Help With Inventory

[Jim Lucas <lists@xxxxxxxxx>]

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>';
	}
}

?>

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php