Re: Getting Results
| From: | Karl DeSaulniers | Date: | Fri, 21 Jan 2011 01:39:15 +0000 |
| Subject: | Re: Getting Results | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-47642@lists.php.net to get a copy of this message | ||
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.comKarl DeSaulniers Design Drumm http://designdrumm.com