PHP problem 1
<?php
// Request the text electronic items
$result = @mysql_query("SELECT oc_oientry,oc_ieentry,oc_sysitem,oc_item,oc_itemdesc,oc_manpub,oc_model,oc_serial,oc_purchasedate,oc_pubmandate,oc_amount,oc_price,oc_retailer,oc_upload1,oc_upload2,oc_upload3 FROM ogden_catalog WHERE oc_sysitem LIKE ('ElectronicItem') ORDER BY oc_item ASC");
if (!$result) {
exit('<p>Error performing query: ' . mysql_error() . '</p>');
}
//creating the table w/ headers
echo '
<table>
<thead>
<tr>
<th style="width:250px"><strong><a href="other-items.php?order=oc_item">Name</a></strong></th>
<th style="width:250px"><strong><a href="other-items.php?order=oc_itemdesc">Description</a></strong></th>
<th style="width:150px"><strong><a href="other-items.php?order=oc_manpub">Manufacturer</a></strong></th>
<th style="width:250px"><strong><a href="other-items.php?order=oc_model">Model</a></strong></th>
<th style="width:120px"><strong><a href="other-items.php?order=oc_serial">Serial</a></strong></th>
<th style="width:60px"><strong><a href="other-items.php?order=oc_amount">Amount</a></strong></th>
<th style="width:84px"><strong><a href="other-items.php?order=oc_price">Price</a></strong></th>
<th style="width:110px"><strong><a href="other-items.php?order=oc_purchasedate">Purchased</a></strong></th>
<th style="width:90px"><strong><a href="other-items.php?order=oc_pubmandate">Manufactured</a></strong></th>
<th style="width:90px"><strong><a href="other-items.php?order=oc_retailer">Retailer</a></strong></th>
<th style="width:90px"><strong>Files</strong></th>
</tr>
</thead>';
// Display each item
while ($row = mysql_fetch_array($result)) {
echo '
<tr>
<td style="width:250px">' . $row['oc_item'] . '</td>
<td style="width:250px">' . $row['oc_itemdesc'] . '</td>
<td style="width:150px">' . $row['oc_manpub'] . '</td>
<td style="width:100px">' . $row['oc_model'] . '</td>
<td style="width:120px">' . $row['oc_serial'] . '</td>
<td style="width:30px">' . $row['oc_amount'] . '</td>
<td style="width:84px">$' . $row['oc_price'] .'</td>
<td style="width:110px">' . $row['oc_purchasedate'] . '</td>
<td style="width:90px">' . $row['oc_pubmandate'] .'</td>
<td style="width:90px">' . $row['oc_retailer'] .'</td>
<td style="width:90px">
if($resultset['oc_upload3']===''){
echo 'fieldname was empty';
}
</td>
</tr>
';
}
echo '</table>';?>
Comments
blog comments powered by Disqus