[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

[PHP-DB] Getting results from MySQL

2003-02-21 Thread Anders Mellström
I have a PHP-MySQl-problem. I would be very greatful if anyone would help me. I am - with the following code - trying to get results from a database. The problem isn't recieving the results, it's where i get the results. All the information is placed far down on the site, not in top. If you're

Re: [PHP-DB] getting results from INSERT

2001-10-26 Thread Bruno Gimenes Pereti
] To: [EMAIL PROTECTED] Sent: Friday, October 26, 2001 9:57 AM Subject: [PHP-DB] getting results from INSERT What i'm after is getting the primary key for a record that's just been added - I have an image file upload accompanying a database addition, and the image gets renamed $unique_ID.jpeg only