[noppid]

Originally Posted by aussiev8

is there anyway of checking if theres a car in the garage or if its empty?
i'd rather not have clickable links for all members, just the ones that have a car?

There is, but you don't want to do it just yet. I have to take a close look at this one or we could add 20 queries to the post loop and I'm not about to cache the entire vbg user table either.

I'm no mysql expert, but what I tried is a LEFT join on the vbguser table in the query that gets the posts. Problem is, there is more then one record per user in vbg. So you see posts duplicated for a user for every garage they have. I will try to figure this out. Maybe someone out there will be kind enough to give a hint.

Of course I could add a field to the vB user table and make it real easy, but I won't commit to DB mod of a vB table.