I'm trying to find a way to have the php code display a message if there is no inventory listed in the box, I just want it to say something like "User has no inventory listed"
You can see the actual box http://modern-wireless-inc.wassociation.com titled Inventory Wizard. Its on the right.
I want all the content in the box disappear if there is nothing in the inventory and only display the message. Is it hard to do?
Code: <?PHP if (!$item)
{
?>
<div class="account-left-column"><div><img src="images/account-left-column-back-top.gif" alt="" /></div>
<div class="account-left-column-header">Inventory Wizard Items</div>
<div class="account-left-column-content">
<form action="search.php" method="get" >
<p>Search <?PHP echo $vuser->co_name; ?> Inventory:</p>
<input type="text" name="q" size="30" maxlength="250" accesskey="S" />
<input name="Submit" type="submit" class="button" value="SEARCH" />
<input name="onlyinventory" type="hidden" value="yes" />
<input name="searchuserid" type="hidden" value="<?PHP echo $v_id; ?>" />
</form>
<table width="260" align="left" cellpadding="2" cellspacing="2">
<tr>
<td colspan="6" align="left" valign="top"> <p>Last 10 inventory items added:</p> </td>
</tr>
<tr>
<td colspan="3" align="left" valign="top"> </td>
</tr>
<tr>
<td align="left" valign="top"><strong>Category</strong></td>
<td align="left" valign="top"><strong>Model</strong></td>
<td align="left" valign="top"><strong>Description</strong></td>
</tr>
<?php
}
$inventories = $db->get_results("SELECT id,category,brand,model,description,qty,price,price_negotiable,picture_1,picture_2,inventory_timestamp FROM inventory where user_id in ($allempids) and status = 'active' order by id desc limit 10 ");
if ($inventories)
{
foreach ( $inventories as $invt )
{
$selected_category_phone = "";
$selected_category_accessory = "";
$selected_category_parts = "";
if ($invt->category == "phone"){$selected_category_phone = ' selected="selected" '; }
if ($invt->category == "accessory"){$selected_category_accessory = ' selected="selected" '; }
if ($invt->category == "parts"){$selected_category_parts = ' selected="selected" '; }
if (!$item)
{
$invt->description = substr($invt->description,0,25);
?>
<tr onmouseover="this.bgColor='#f1f0f0'" onmouseout="this.bgColor='#FFFFFF'">
<td align="left" valign="top">
<?PHP echo $invt->category; ?> </td>
<td align="left" valign="top">
<?PHP echo $invt->model; ?></td>
<td align="left" valign="top">
<a href="inventory.php?view_id=<?PHP echo $v_id; ?>&item=<?PHP echo $invt->id; ?>">
<?PHP echo $invt->description; ?>...</a></td>
</tr>
<?php
}
else
{
?>
<?php
}
}
}
?>
</table>
<div class="account-button"><a href="inventory.php?view_id=<?PHP echo $v_id; ?>">See All Inventory</a></div></div>
<!-- end of .account-left-column -->
<div><img src="images/account-left-column-back-bottom.gif" alt=""/></div></div>
TimeZoneOffset
Hello,Please i need your help. I have a system that users can use to punch in and out. This system has been working fine however the time went one hour behind on sunday and since then the system has
How to secure my login data to my database?
Hi there,It may be a stupid question but I don't know how to secure my login data to my database. I have created an include file in order not to have these data in the code of my pages, but I don't
Parse multirow HTML table
Hello all, I have a site I am working on. Its a sports site and I am trying to add stats to a DB. I have a table that will have varying amounts of rows depending on how many kids are on the team. I
Warning message
I've put a website that I was doing live and I'm getting this warning message when I try to add a new user when I'm not logged in. It should redirect me back to the login page but I get this
for some reason mysql query not working, not inserting, please check it out
This code is not inserting anything into my db, don't know why, the $_SESSION variable does contain data.Please have a look.Code: function add_user_to_db() {
displaying email without attracting a ton of spam
Hello,this is maybe the wrong place to ask.How would you display an email address on a website without attraciting all the spammers of the world to fill your mailbox ?does anybody use something
Working with popups and such in a class
I've recently started building my applications completely enclosed in classes. I like the fact that I can base everything off one root and work with that, but I'm having a problem with popups
About imagecopyresampled()
Hello,I am looking to use this function to resize parts of an image to a fixed thumbnail size. I have used this functions many times, but I am trying to become more advanced as time pass by.I have
Pagination
Hi All,I think I'm finally getting somewhere with pagination!I can now submit a query and get the correct number of records back with the correct number of pages. My only problem is, when I press the
Is it possible to view php source code??
Hi AllI was just wondering if it's possible to view a websites php source code? I know that php is a server side scripting language and that it is processed at the server and the results are sent