Re: Getting Results

Hi Robbyka, ."USERS." and ."VIP." are constant variables used to hide the actual names of the tables for security reasons. Those variables will have content. Not sure what you mean by "semi locon like => from ".users";" The user names are set up to be unique. No two user names can be identical and the users in the VIP table come from the USERS table to begin with. I am simply trying to get the VIP users info without having to fill the VIP table up with duplicate info that is already in the users table. The only thing going into the VIP table is the username, and a time stamp. Thanks for your help though, I think that is what I needed. Still need to test. Best, Karl On Jan 20, 2011, at 7:50 PM, Robbyka Gheo wrote:

how many your tables? why you use semi locon like => from ".users"; i think if you use that the query look ".users" as variabel and you must have content it that variabel.. and better use unique id both of vip and users table. On Fri, Jan 21, 2011 at 9:39 AM, Karl DeSaulniers <karl@designdrumm.com> wrote: 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@designdrumm.com> 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

Karl DeSaulniers Design Drumm http://designdrumm.com