Hi Karl,
What about:
$q = SELECT username, userlevel, email, timestamp FROM Users_Table WHERE
username IN (SELECT username from VIP_Table) ORDER BY username ASC;
This performs a query on the VIP table to get the usernames and then gets the
username, userlevel, email and timestamp from the
I did not know you could do a SELECT inside a SELECT. Very nice!
Thank you Andrew. And I take it ASC is in ascending order?
So to do descending order I'd put DES or DEC? Just curious about that
one.
Thanks again.
Best,
Karl
On Jan 21, 2011, at 4:48 AM, Andrew Holt wrote:
Hi Karl,
What
On 21 January 2011 11:58, Karl DeSaulniers k...@designdrumm.com wrote:
I did not know you could do a SELECT inside a SELECT.
Commonly known as a sub select.
You can use them like ...
SELECT columns
FROM ( SELECT columns FROM table)
WHERE column IN (SELECT column FROM table)
As part of a FROM
Ahh yes, I remember that now.
Thank you.
Karl
On Jan 21, 2011, at 6:17 AM, Richard Quadling wrote:
On 21 January 2011 11:58, Karl DeSaulniers k...@designdrumm.com
wrote:
So to do descending order I'd put DES or DEC? Just curious about
that one.
ASC and DESC
--
Richard Quadling
Twitter
Very informative,
Thank you Richard.
I will have to flag this one and come back to it.
My database structure may require something of this measure down the
line
with the auditing ability I plan on building into the admin section.
Never heard of USE AdventureWorks. Is that a SQL system
On 21 January 2011 12:39, Karl DeSaulniers k...@designdrumm.com wrote:
Very informative,
Thank you Richard.
I will have to flag this one and come back to it.
My database structure may require something of this measure down the line
with the auditing ability I plan on building into the admin
[EMAIL PROTECTED] (Anders mellström) writes:
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