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>
Passing PHP variables from one page to another
Hello-I'm having trouble figuring out how to transport a variable from one php file to another. Specifically, the name of an image, to be used as a subject in a form mail. I don't even really have the
Save User Inputs while javascript reloading!
hi..i have written a PHP code in which i reload the page when user selects a value in dropdown...Code: function reload(form){var
How to create a static html menu from a database
Hi,I have built a small cms which allows me to create simple html pages and then upload them to an ftp.Everything is working apart from the menu, I cant get my head round how to create the menu
upload image name with extension using php
hi frds..<input id="file1" type="file" name="file[]" >upload image show path like C:\Documents and Settings\My Documents\My Pictures\images0056.jpgi need
How do I get the row number from from an sql table query
Hi allI have a table that I query and it returns a number of rows.mysql_num_rows($query) = $totalI want to have next and previous buttons, is there a way of retrieving the current row number, and can
InternetOpenUrl() Invalid cert
Hi all,
is this the proper use of mysql_real_escape_string() to prevent sql injections?
i was wondering is this the proper use of mysql_real_escape_string() to prevent sql injections? any help greatly appreciated. thanks. derekCode:
Pass sql into pl/sql and create RMAN duplicate script.
Hi,
PHP and SMS
Hi all forum members. I am new here and am unsure what category shoild I post this in. Moderators: Please excuse me if this is in the wrong category.The problem is that I am assigned with the task of
with clause
hi all, i have a big query that usually access the same table more than once. for example, i have something like this