Programming Forums - View Single Post

Styx · Mar 29th, 2007, 8:05 PM

hm, you can try something like this:

SELECT g.GameName FROM members m, games g
  WHERE m.Username = '$Username'
  AND m.Password = '$Password'
  AND m.Game1 = g.GameID
  AND m.Game2 = g.GameID
  AND m.Game3 = g.GameID
  AND m.Game4 = g.GameID
  AND m.Game5 = g.GameID

Mar 29th, 2007, 8:05 PM	#2
Styx Programmer Join Date: Mar 2007 Posts: 39 Rep Power: 0	hm, you can try something like this: (Toggle Plain Text) SELECT g.GameName FROM members m, games g WHERE m.Username = '$Username' AND m.Password = '$Password' AND m.Game1 = g.GameID AND m.Game2 = g.GameID AND m.Game3 = g.GameID AND m.Game4 = g.GameID AND m.Game5 = g.GameID SELECT g.GameName FROM members m, games g WHERE m.Username = '$Username' AND m.Password = '$Password' AND m.Game1 = g.GameID AND m.Game2 = g.GameID AND m.Game3 = g.GameID AND m.Game4 = g.GameID AND m.Game5 = g.GameID