The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
sql problem
ok i have this bit of code
############TOP country $getstats_country = $DB_site->query("SELECT userid, username, country FROM user ORDER BY country DESC LIMIT 0, $displayrecords"); while ($getstats_country = $DB_site->fetch_array($getstats_country)) { eval('$stats_country .= "' . fetch_template('forumhome_stats_country') . '";'); } but when i run it i get sql error i think its cos the country field is in the userfield its one i added as a profile field its field 8 Database error in vBulletin 3.0.7: Invalid SQL: SELECT userid, username, country FROM user ORDER BY country DESC LIMIT 0, 10 mysql error: Unknown column 'country' in 'field list' is it the code or the field 8 i should be calling the aim is to list the top countrys thanks for any help |
#2
|
|||
|
|||
I think it's field 8 you should be calling, but I'm only beggining to learn MySQL...
|
#3
|
||||
|
||||
PHP Code:
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|