Hey VB developers!! Don't miss this thread, there's definitely issues with the php vbcode!! The above "&n" actually reads "LIMIT 100", even when I edit it but no matter what i do it shows as &n
weird.

note that the code I gave you got chopped, run it w/ the limit 100...

I thought an extra row may show up w/ some missing data....if not I'll look at the code again....somehow reflistbit is being called one time too many...

I had to take out the &n because it said it was an invalid SQL statement... Could that be the problem?

You have an error in your SQL syntax near '&n LIMIT 0, 30' at line 7

since the php vbcode isn't working, once again, here's the proper code to try:

"SELECT COUNT(*) AS referrals, user.username, user.userid FROM user AS users
LEFT JOIN user ON (users.referrerid = user.userid)
WHERE users.referrerid <> 0 AND
user.userid NOT IN (0)
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT 100"

You have an error in your SQL syntax near 'LIMIT 0, 30' at line 7

You're using an old version of phpMyAdmin....just pull off the LIMIT 100 portion...then scan the results.

If there's more than 30, be sure to go to the next page and check that every line is ok.

I am using the newest version of phpmyadmin... Everything that was pulled with that SQL looks alright... BTW whats your URL?

My boss won't let me post my url :(

OK, I have a question. How many rows were returned from the sql statement? It should have been 7.


Josh
Kckazdude
pug
DonnieD
cryzten
1gigkid
Andrew

Yes, that is correct. Maybe its just a mistake in the php file or one of my templates...