Let me set this up.
two databases D, S connected by a CustID
both contain multiple entries of the Cust ID.
database S has a field called type that has a set number of possibilites 222.
so I select distinct on CustID from both tables.
I want to know if are at least 100 entries for a particular CustID. I now odbc_num_rows doesn't functions as said. I know I can loop through and count but I don't want to if I don't have to.
Is it possible?
Ace21
two databases D, S connected by a CustID
both contain multiple entries of the Cust ID.
database S has a field called type that has a set number of possibilites 222.
so I select distinct on CustID from both tables.
I want to know if are at least 100 entries for a particular CustID. I now odbc_num_rows doesn't functions as said. I know I can loop through and count but I don't want to if I don't have to.
Is it possible?
Ace21