On 21 January 2011 12:39, Karl DeSaulniers 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 section.
>
> Ne
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 functio
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
wrote:
So to do descending order I'd put DES or DEC? Just curious about
that one.
ASC and DESC
--
Richard Quadling
Twitter : EE : Zend
@RQuadli
On 21 January 2011 11:58, Karl DeSaulniers wrote:
> So to do descending order I'd put DES or DEC? Just curious about that one.
ASC and DESC
--
Richard Quadling
Twitter : EE : Zend
@RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY
--
PHP Database Mailing List (http://www.php.net/)
To unsubsc
On 21 January 2011 11:58, Karl DeSaulniers 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 or as part of a WH
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 a
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 Use
