Google+ Tools
Make Google+ profile picture
Make Google plus banners for profile
Create and share your Google Plus profile banners.

Profile image for mrk studios Mainer82 on August 3, 2012

Comments

Language
PHP
Tags

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