PDA

View Full Version : Need info from database - MySQL/PHP


King Justice
04-18-2010, 08:52 PM
Hello can anyone help me ?

I want to call & display certain info that I know is in my MySQL database of my forum.

I want the users with the most iTrader feedback to display. Can anyone help me by providing me a code to call this via MySQL/PHP? I'd like it to list the users in descending order, from highest feedback ratings to lowest.

Pandemikk
04-18-2010, 10:37 PM
Read this: http://www.vbulletin.com/docs/html/main/codestandards_sql_query

If you still have questions you'll need to provide us with information on how your information is stored in your database. This can be found out in phpMyAdmin.

King Justice
04-19-2010, 12:49 AM
Well it's vBulletin so I figured someone would easily be able to tell me how to list the users with the most iTrader ratings in decending order by username (I want it to display the username and the number of feedback they have in a list in descending order).

iTrader is a plugin for vbulletin. Anyone?

Lynne
04-19-2010, 03:48 AM
You'll need to ask this in the modification thread. This is in regards to fields added to the database for a modification and so that is the place you need to ask your questions. (We certainly have no idea what fields were added by the mod - only those who have installed the mod would know that.)

Pandemikk
04-19-2010, 08:48 AM
Well it's vBulletin so I figured someone would easily be able to tell me how to list the users with the most iTrader ratings in decending order by username (I want it to display the username and the number of feedback they have in a list in descending order).

iTrader is a plugin for vbulletin. Anyone?

The problem is I am not familiar with iTrader thus I do not know what it alters or how it does so.

Lynne is correct, you should be asking for support at their offical website/thread. If they don't give support I'd be happy to assist you, provided I am allowed, but I will need more information.