Thanks Robbyka,
The username would be what your referring to with the .idvip
So..
"select username, userlevel,email, timestamp from ".USERS.", ".VIP."
where ".VIP.".username=".USERS.".username;
yes?
Karl
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
<karl@xxxxxxxxxxxxxxx> wrote:
Hello,
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.
TIA,
Karl DeSaulniers
Design Drumm
http://designdrumm.com
Karl DeSaulniers
Design Drumm
http://designdrumm.com
