Thanks Robbyka,
The username would be what your referring to with the .idvip


"select username, userlevel,email, timestamp from ".USERS.", ".VIP." where ".VIP.".username=".USERS.".username;



On Jan 20, 2011, at 7:24 PM, Robbyka Gheo wrote:

i think its wrong, try this script?
"select username, userlevel,email, timestamp from users, viptable where viptable.idvip=users.idvip;

i asumsion the viptable.idvip is relation with users.idvip;

On Fri, Jan 21, 2011 at 9:01 AM, Karl DeSaulniers <> wrote:
Can anyone tell me if I am doing this right? Or how to do this right?
Not sure on what to search for. What the search term would be for this type of call to the database.

$q = "SELECT username,userlevel,email,timestamp FROM ".USERS." ORDER BY username FROM ".VIP." ";

I am basically trying to get a list of user info from the user table based on the usernames that are in the vip table.


Karl DeSaulniers
Design Drumm

Karl DeSaulniers
Design Drumm

Reply via email to