The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Getting burnt....need help, please.
I need another pair of eyes to help me with this query, first I will list the schema of both tables,
membergames: membergamesid userid gameid games: gameid gamename here is the query I'm trying to create which is listing all the available games in the games table and then using a makeyesnocode to give the option to select the game and also provide for the one the user has already selected, it's not working right (see screenshot). Here is the query I'm using: PHP Code:
|
#2
|
||||
|
||||
How high does gameid numerical wise?
|
#3
|
|||
|
|||
Quote:
it is set to smallint (5) and right now my highest game is gameid=20 There is nothing here that will affect my results... |
#4
|
|||
|
|||
Hmmm...have I stumped the anyone here?
|
#5
|
||||
|
||||
You're pulling each part of this out of 2 different queries:
PHP Code:
|
#6
|
|||
|
|||
Quote:
PHP Code:
|
#7
|
|||
|
|||
Ok...figured it out...here is the new code:
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:
|