[SOLVED] mysql selection problem

[mforan]

$query = "SELECT username,alliance,reports,repip,lastip FROM users WHERE reports >0 ORDER BY username ASC";
$result = mysql_query($query) or die("Error: ".mysql_error());
while ($row = mysql_fetch_array($result, MYSQL_NUM)) { $pow2[] = $row; }

 

^^^ i want to run the above mysql, but i also want to select "lastip" if the report isnt over 0, but the lastip also exsists on one of the selected ones.

 

so i want to select these 2 because 1 contains 4 or >0:

 

112 0

112 4

(the above code would only select "112 4")

 

any ideas peeps?

[wildteen88]

Use >= rather than >

[mforan]

that would select all the values in the database since everyone or every entry has default of 0 lol.

[mforan]

never mind i had a better and probably easier idea, change the way the entry is added in the first place, rofl.