$q = "SELECT username, userlevel, email, timestamp FROM Users_Table WHERE
username IN (SELECT username from VIP_Table) ORDER BY username ASC";
This performs a query on the VIP table to get the usernames and then gets the
username, userlevel, email and timestamp from the Users table if the username
is in this result.
There are some tutorials which I often refer to when I need a refresh (not all
programming in my job unfortunately!):
Hope this helps!
From: Karl DeSaulniers [mailto:k...@designdrumm.com]
Sent: 21 January 2011 01:02
Subject: Getting Results
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.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php