/ Published in: PHP
URL: None
Comments
Expand |
Embed | Plain Text
<?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) { } //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 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']===''){ } </td> </tr> '; }
You need to login to post a comment.
