Batch numbers for the same product....

[thedream]

Hi there,

I have an eshop and I am going to sell some medics products. Every medical product have a Batch (serial) number as "CD025421G23" or something.

I am on PHP and Mysql.

What is the strategy for:
Where there is no more of the ABC product with the batch number N° XY123, the same product with the batch number N°CD456, take place.

Does I have to make 1 row per product and some magic PHP code or do you have another strategy?

Please help.

MArc :queasy:

[amchargue]

something like

$query = mysql_query("select id, name, batch_no from product");
while ($myrow=mysql_fetch_array($query))
{
  $query_inv = mysql_query ("select number_in_stock, product_id, priority from inventory i where i.product_id=$query['id'] order by priority");
  while ($myrow_inv=mysql_fetch_array($query_inv))
  {
    if ($myrow_inv['number_in_stock']>0)
    {
      << some output >>
      break;
    }
  }
}

priority would be a field where you could determine which product will backup another. If it finds product, it will break out of the loop. If product is out of stock, it will continue to the backup product.

🆒

[thedream]

thank you for your answer, I am gona try this. Thanks again.

MArc