[SOLVED] Query a Query

[eightFX]

Is it possible to query a query using PHP and MySQL? Better yet is there a way to get this to work the way I want:

 

$query = mysql_query("SELECT * FROM tester ORDER BY date DESC, name LIMIT 10 ");

while($result = mysql_fetch_array($query)) {       

echo '' . $result['name'] . ' - ' . $result['date'] . '';

}

 

I want to pull the ten most recently added people (tracked with date) but sort them alphabetically for the output...

 

Thanks for any insight, major brain cramp on this one...

[Barand]

SELECT * FROM
       (SELECT * FROM tester
          ORDER BY date DESC
          LIMIT 10) as a
ORDER BY name

[eightFX]

That does not seem to work in my code, this is what I used:

 

 

$query = mysql_query("SELECT * FROM (SELECT * FROM tester ORDER BY date DESC LIMIT 10) ORDER BY name");

while($result = mysql_fetch_array($query)) {       

echo ' ' . $result['name'] . ' - ' . $result['date'] . ' ';	 

}

 

The error I receive is:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in test.php on line 17

 

Line 17 is: while($result = mysql_fetch_array($query)) {     

[Barand]

You left out the alias for the subquery

[eightFX]

Good call! Thanks, it has been that kind of day! Got to love Mondays!