na, actually that's SQL thing...nothing to do with vB. ;)

when joining tables, you should specify the TABLE_PREFIX on the table AND field names.
if pulling only ONE table, you do not need the TABLE_PREFIX on the select list, just the table name.

thanks for listening! :D




and GREAT hack btw!

I'll have to remember that in the future. Thank you, sir, for informing me of this. It's good to know. ;)

Don't forget to vote for the Hack of the Month for March. This hack is in there. ;)

Seems like I am the only one who is having style problems? I have a default vB3 template, but the style is messed up!

Check it out at http://www.invoid.net

[high]* Mijae clicks install after posting.[/high]

Try changing this:

to this:

and let me know if it fixes it.

Also, %'s arent showing up! Hrm!

This is what I see:

ivForums Statistics

Didn't fix it.

Here is a SS of what I see:

Ok, try this then:

Change:

to:

Hang in there, we'll get it. ;)