[PHP-DB] Getting Results

2011-01-20 Thread Karl DeSaulniers
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

Re: [PHP-DB] Getting Results

2011-01-20 Thread Karl DeSaulniers
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

Re: [PHP-DB] Getting Results

2011-01-20 Thread Karl DeSaulniers
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