Active status is what I want to default to YES. Right now I need to approve a new link and then go back and further edit it to "active" to appear on my list.

As far as the links awaiting approval go... if the query calling up the list of affiliates in the admincp (manage affiliates) was reversed so newest was shown first instead of last it would place anything needing attention on the first page instead of buried several pages back. I just haven't found the right query to make the change yet...

I changed the sort order to display the sites awaiting approval first, then the sites that are approved but inactive, then the sites that are approved and active.

Exactly what I'm after... care to share where that query is?

I don't remember offhand hat the original line looked like, but just search for $faffiliate= $DB_site->query as I only found that once in the file. ;)

Exactly what I needed. Much appreciated Majik.

thanks:), you saved me alot of work;)

Last small item for me to sort out... it seems that if the site description text gets too close to the edge of a cell on the affiliate list page I lose the left side border for that cell. Cells affected will change as window size or screen resolution is changed depending on where the text wraps. Any ideas of how to address this?

Can anyone offer any suggestions on what else I might try because I'm baffled by this one. I've played with cell padding and font sizes to no avail and the left boders continue to disappear where ever text comes within a certain margin width. I just dunno... :disappointed:

well each cell doesnt have a border, the border you see is the background of the table:) try increasing cellpadding and cellspacing:)