Jump to content

spiderwell

Members
  • Posts

    1,008
  • Joined

  • Last visited

Posts posted by spiderwell

  1. one way to approach it would be to put the order items details enquiry in the loop of the first query, so as you iterate through all the orders, make a call to the details part as you loop through the recordset of the orders.

     

    first query here for list of orders

    while (looping through the orders)

    {

      use the second query here to get item details by passing the id of the order.

    }

     

     

  2. how about using the mysql_num_rows() function?

     

    $query = "SELECT pid FROM products WHERE productgroup = 'Some Group'";
    $result = mysql_query($query);
    $num_rows = mysql_num_rows($result);
    

     

    I havent checked this snippet for typos so it might not run from cut n paste

  3. so essenetially you want to split a 24hour period equally and show it as a timestamp? or something like that? although your example does exclude the first minute of said period.

     

    I am guessing this split could be 2,3 ,4 or more? thus becoming 12hr,8hr,6hr etc periods?

     

     

     

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.