The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
Data Base Query?
Hello,
I have a list of data to pull and I have the query for most of the data as you can see. I need to add e-mail addresses and usernames to this somehow and I am having a hard time getting this to work. Here is what I have so far..... PHP Code:
Thanks |
#2
|
||||
|
||||
user.username and user.email are the fields you would add to the SELECT statement.
|
#3
|
||||
|
||||
I don't know why but that wasn't working. I must be doing something wrong. I figured I was missing something..
Thanks so much Lynne, I will try again and figure out what I was doing wrong... Thanks Lynne... Just me being stupid again.. PHP Code:
Thank you very much.. |
#4
|
||||
|
||||
Hehe. Usually I put the commas at the end of the line. It just makes it easier for me that way.
|
#5
|
||||
|
||||
It's good practice to put commas before on SQL, as it's much easier to see them this way.
Code:
SELECT user.username , user.email , userfield.userid , userfield.field19 , userfield.field20 , userfield.field12 , userfield.field13 , userfield.field18 , userfield.field14 , userfield.field15 , userfield.field16 FROM userfield INNER JOIN user ON user.userid = userfield.userid WHERE user.usergroupid = 15; |
#6
|
||||
|
||||
Quote:
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|