how do i get the column names of the avatar table? - vb.org Archive

		vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
how do i get the column names of the avatar table?

Reply

#1

Old

07-30-2008, 03:06 PM

octokevin

octokevin is offline

Join Date: Jul 2008

Posts: 6

Благодарил(а): 0 раз(а)

Поблагодарили: 0 раз(а) в 0 сообщениях

Default

how do i get the column names of the avatar table?

Does anyone know how I can find out the column names for the avatar table in the database?

I see the mysql statement in profile.php that gets the predefined avatars, and it does an ORDER BY avatar.displayorder.

I want to do an ORDER BY avatar.name but I don't know the name of the correct column name.

Reply With Quote

#2

Old

07-30-2008, 05:15 PM

Opserty

Opserty is offline

Join Date: Apr 2007

Posts: 4,103

Благодарил(а): 0 раз(а)

Поблагодарили: 0 раз(а) в 0 сообщениях

Default

[sql]
DESCRIBE table_name
[/sql]

Reply With Quote

Reply

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Forum Rules

Forum Jump

All times are GMT. The time now is 08:47 AM.