1 Main Public Page
 > User Viewable Page (organized list of brand {I.E. Cisco, 3web, etc.} type of hardware {I.E. Switches, Routers, Etc.}, then by model {I.E. under Switches, have a 2950T, 2950G, 2950-48, etc.}, then after clicking on that specific model, display an image of the item, a quick summery, and how many we have in stock via method listed below). It should calculate stock by number of serial numbers in the database.

Several Main Backend Pages, viewable only by registered users.Guess I'll have to use SSL or something for that, will have to research it.

For Products:
 > One form that allows users to enter in Manufacturers (Cisco, Bay, Etc.)
 > One form that allows users to enter in Items (Routers, Switches, Etc.)
 > One form that allows users to enter in Model Numbers (2950T, 2950G Etc.)
 > One form that allows users to enter in Company Names and info (For who we buy from)
 > And one form that allows users to enter in a company name and info for customers
 > One form that allows users to enter in several things after. I want this form to have drop down menu's of Manufacturer, Item, and model number. After you pick those on the form, it should have a text box to enter in the serial number, a check box stating whether or not the device is working, a text box allowing user to enter in either the problem with the device if it's not working or any extra comments if it is working (I.E. Item doesn't power on if check box is for not working, or Item has a small scratch on the top left if box is checked working), and then a drop down menu of where it is located (which would be really cool if it could default to a section when the manufacturer, item and model is chosen, and I would probably just set this manually, as once we set sections of shelves, like A1, B3, etc., they won't change). I would also like there to be an Add button, so I can either enter in one item, or if we happen to get say 20 that day, then I can just press the Add button to add another row of the serial number, working, and all the stuff above, kind of like a multiple product at a time using the same manufacturer, item and model number (example, I want to add 5 Cisco 2950T Switches, and one at a time would take forever, where as if I could just pick Cisco, Switch, and 2950T, then add 4 more rows to the original first row to enter in a total of 5 serial numbers and what not, it would save a ton of time).

And that's pretty much it for raw products.

From there, I would like 3 more main back end pages. The most important being for ordering.
 > This is where I'd want the PDF bit. I'd essentially like it to look like this (hxxp://www.pcwaterloo.com/makequote.php), copy and paste, change xx to tt, it allows you to add products one by one, sums up price, and I'd also want it to allow us to chose tax (we don't have to charge anyone but those in ontario PST, and we don't have to charge anyone outside of Canada GST) and have it automatically calculate. After saving that order to the database, it throws it into a PDF file that already contains our letterhead, policies, date, etc. so that if we want to later we can pull up an order number and view that order made and change it, re print it, whatever. I also want the actual order form to remove items from the database. For example, if I want to ship 10 Cisco 2950T Switches, I want to be able to just enter in 10 serial numbers, have it search the database, tally it up (quality 10 of whatever switch or whatever), and then add the price etc. and list all the serial numbers after that. After saving the order form, it should remove those 10 serial numbers from the database and essentially remove 10 items from stock.

The second one would be for RMA. I'd like to be able to give an RMA number to a customer and enter in the serial numbers for the RMA and the problem and company and what not, store it for record keeping etc. and have a page to view it.

The third one would be for searching, quite basic, I want to type in a serial number, have it search the database and result to me what it is. I want it to show all the information, manufacturer, item, model, serial number, if there was a problem, all the fun stuff. Just want the ability to see where it came from and if there was a problem really so we can better track end user problems.

if((strlen($prod_id) < 10) and (is_numeric($prod_id))) {
    echo "Product ID field is valid";
} else {
    echo "Product ID field is too long and/or not numerical and therefore invalid";
}

<form action="process.php" method="post">
  <select name="provider">
    <option value="Cisco">Cisco</option>
    <option value="3Com">3Com</option>
  </select>
</form>

<?
  echo $_POST['provider'];
?>

<?   
    // Variables used to store database information, change as needed   
    $host = "localhost";
    $user = "";
    $pass = "";
    $dbse = "";
   
    // Create the connection
    $conn = mysql_connect($host, $user, $pass) or die("Could not connect to server!");
   
    // Select the database
    mysql_select_db($dbse, $conn) or die("Could not select database!");

    // Build the query and execute it.  This will change.
    $q = "SELECT * FROM dropdownlist WHERE list=\"name\"";
    $r = mysql_query($q);

    // Makes sure something was found to avoid errors
    if($r == 0) die("<p><strong>0</strong> results found.</p>");

    // Fetches the results of your query and makes a dropdown list out of them
    while ($row = mysql_fetch_assoc($r)) {
        echo "<option>".$row."</option>";
    }
?>

  `inventory_company` varchar(32) collate latin1_general_ci NOT NULL default '',
  `inventory_product` varchar(32) collate latin1_general_ci NOT NULL default '',
  `inventory_model` varchar(32) collate latin1_general_ci NOT NULL default '',
  `inventory_serial` varchar(32) collate latin1_general_ci NOT NULL default '',
  `inventory_working` varchar(32) collate latin1_general_ci NOT NULL default '',
  `inventory_comment` varchar(32) collate latin1_general_ci NOT NULL default '',
  `inventory_supplier` varchar(32) collate latin1_general_ci NOT NULL default ''

<?
  $q = "SELECT * FROM inventory WHERE list=\"name\"";
    $r = mysql_query($q);
    if($r == 0) die("<p><strong>0</strong> results found.</p>");
    while ($row = mysql_fetch_assoc($r)) {
        echo "<option>".$row."</option>";
    }
?>

<?
  $q = "SELECT * FROM inventory WHERE list=\"name\"";
    $r = mysql_query($q);
    if($r == 0) die("<p><strong>0</strong> results found.</p>");
    while ($row = mysql_fetch_assoc($r)) {
        echo "<option>".$row["inventory_company"]."</option>";
    }
?>

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\netit\test.php on line 14

$fields = array("id", "d", "t", "l", "h", "v", "type");

        // Find all games for that team
        $q = "SELECT * FROM $div WHERE h = \"$team\" OR v = \"$team\"";
        $r = mysql_query($q);
        if($r == 0) die("<p><strong>0</strong> results found.</p>");

        while ($row = mysql_fetch_assoc($r)) {
           
            foreach($fields as $value) {
                echo $row[$value];
            }
            echo "</tr>";
        }