MySQL subquery not working
===

I have a DB with multiple ip addresses....(don't ask)

This is what I want to do:

    $getdata1 = mysql_query(" SELECT id  FROM ( SELECT DISTINCT(ip_address), id, sourceID FROM $database_table8 WHERE sourceID = '$pageID_1' ) AS ip_addresses " ) or die('Cannot complete GET DATA query STATS 5 because: ' . mysql_error();


That works.... BUT it gives the same number of rows as this....

    $getdata2 = mysql_query("SELECT DISTINCT(ip_address) AS ip_address, id, sourceID  FROM $database_table8 " ) or die('Cannot complete GET DATA query STATS 2 because: ' . mysql_error();


What is wrong with my first query... the answer should be substantially less than the answer from query two...  ???

Thanks for you guys help !!

