Okay. yes i ask alot of questions. and yes i do look on the net most of the time.

so what i am trying to do is create a small php object inside of a php page were it querys a table called sales. now what i am trying to do is for it to get the total "so" (sales orders) and the total completed and show how many orders filled and how many outstanding.

here is that exerpt

PHP Code:

<?php 
          require_once 'dbconnect.php';
          $sql = mysql_query("SELECT * FROM sales WHERE order='$orderid' AND ordercompleted='$ordercomp'");
          $ordercheck = $sql;
          
          if ($ordercheck > 0) {
          
           ?>

i think thats how it should be set up so far

Any help appreaciated

Thanks in advance

you could have a field which says sales_status, like 0 meaning outstanding, 1 meaning completed, 2 meaning cancelled or something like that. I do this with any ticket type systems.

Then if you wanted to split them up into some sort of list you could either do two queries, or do one big one and do a loop to place completed in one array and outstanding in another and do whatever you want with them.

Did i understand what u were asking?

sort of...

thats is what i am hoping to be my end goal.

another question how would i lock table sizes.. to prevent them from resizing