Re: Fwd: Hmmm.. I think I need your advice here to get in correct direction...

On 7/10/2013 8:37 AM, Karl-Arne Gjersøyen wrote:
> Sorry, the first mail in this subject run out for me. This is an updated
> one.
>
>
>
> I am almost ready with my learning project in PHP/MySQL.
> I can register new product in stock.
> Add and increase the number and weight.
> I can move products between different storehouses
> I can also transfer products from store and onto a "truck document" but
> that's it and here I need some advice.
>
> I like to register new products and the amount in number (for example 4)
> and weight in kg.
>
> I like to write it in this way:
> Dynamite - package 4 - Weight 200 kg
> Lunt - Package 10 - Weight 10kg
>
> Then I like to 4+10 = 14
> and 200+10 = 210.
>
> It shall looks like this:
> ======================================
> Dynamite |  4  | 200
> Lunt         | 10 |  10
> ------------------------------------------------------------------
> TOTAL    | 14 | 210
>
> It is easy to register this product by product on their own row.
> but in what way can I multiply them? ned products be stored in arrays?
> I think it will be similar to shopping cart in online store but i have no
> clue about how to do this.
> If you have links to pages were i can learn am i Happy for it. If you can
> help me here is even better.
>
> Thanks for your time and effort to learn me programming.
>
> Karl
>
>
>
>
Ahhh.....

So - you should run a query that selects the products and information 
that you want.  Then you start by creating an html table header and then 
loop through your query results and echo a table row for each result row.

// start the table
echo "<table border=1>";
echo "<tr><th>Product</th><th>Amount</th></tr>";

// loop thru each item found
while ($results = $qrslts->fetch(PDO::FETCH_ASSOC))
{
    echo 
"<tr><td>".$results['product_name']."</td><td>".$results['product_amt']."</td></tr>";
}

// finish the table html
echo "</table";