It's a no go...
This is what I tryed:
SELECT User.NickName FROM User, Rights WHERE (User.UserID =
Rights.UserID (Rights.MainID = ${row['MainID']} ||
ISNULL(Rights.MainID))
The only thing I want to be able to retrieve is a list of nicknames
(User.NickName) based on MainID. In the Rights
On Monday 22 April 2002 16:04, Prodoc wrote:
It's a no go...
This is what I tryed:
SELECT User.NickName FROM User, Rights WHERE (User.UserID =
Rights.UserID (Rights.MainID = ${row['MainID']} ||
ISNULL(Rights.MainID))
The only thing I want to be able to retrieve is a list of nicknames
Does the simple case (without specifying MainID) work?
And are you pretty sure that $row['MainID'] actually holds a valid value?
Have you tried printing the whole of the above query to see what it actually
contains?
If it looks valid try copy-paste that query into the mysql
that the above SEQUENCE is important. If you deviate from it,
you may get unknown variable or other error messages.
-Szii
- Original Message -
From: Prodoc [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 22, 2002 2:38 PM
Subject: Re: [PHP-DB] Re: Retrieve information from mutiple
E.g. I've got two tables (User and Rights) both contianing UserID, I
want to retrieve some UserID's from the Rights table and use those
UserID's the get the nickname of those users from the User table.
(SELECT UserID FROM Rights WHERE...)
(SELECT NickName FROM User WHERE...)
On Monday 22 April 2002 00:53, Prodoc wrote:
E.g. I've got two tables (User and Rights) both contianing UserID, I
want to retrieve some UserID's from the Rights table and use those
UserID's the get the nickname of those users from the User table.
(SELECT UserID FROM Rights WHERE...)