mikeyk

Exactly what I was looking for. Thanks - again!

Yes, I want a number as a output. But not like total number of entries by customer. More like counting each row asc order if the customer is same. So that first record of Customer1 would show up #1 and sixth record #6 and 2,3,4,5 between those.

Thanks for your reply. But I'm not sure how I could achieve my goal with that.. The problem isn't ordering the rows, problem is counting the rows by customer. So that every customer's first row is #1, second #2 and so on.. If that can be done by your code then I just can't figure it out... #1 Customer1 #2 Customer1 #3 Customer1 #1 Customer2 #1 Customer3 #2 Customer3 ....

Are you ordering by NUMBER or by CUSTOMER? By customer because number isn't a field in database. I maybe expressed myself badly. What I'm trying to achieve is to count 1,2,3,4.... for each entry by same customer. And to do that automatically so if I add/delete entry it shows right. Got the pointT

Hi again. Now that the colors are working I thought of taking this a bit further. Same idea, customer matters. This is what I'm after: +----+----------+------+--------+ | # | customer | case | status | +----+----------+------+--------+ | 1 | Mollie | c1 | Active | | 2 | Mollie | c2 | Closed | | 1 | Drew | c3 | Active | | 2 | Drew | c1 | Active | | 3 | Drew | c4 | Pend | | 1 | Ed | c2 | Active | | 1 | Sara | c1 | Closed | +----+----------+------+--------+ So first field would count numbers ascending order by customer. Been trying to solve this for past 3 hours with no luck.. Any ideas? Thanks in advance.

Wow, that was fast! Got it working, thank you both very very much. And to nethnet: You guessed it pretty close Thanks!

Hi. I have a MySQL database with 4 different fields. id, customer, case and status. No problems of getting them to show up on my page but.. I would like to change the row bgcolor depending of field value on "customer". For example row color would be white until customer changes, then color yellow until customer changes again and back to white etc.. Hope you get the point. Is this possible? Thanks.