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@xxxxxxxxxxxxxxx> 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@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
Karl DeSaulniers
Design Drumm
http://designdrumm.com
