Hello, Me again I have a query select * from advertisers WHERE hits_left = '0' PHP: this query only works if hits_left = '0' but i need it to work if hits_left = '0' or if hits_left = '-1', hits_left = '-2', hits_left = '-3', ect... Basicly if hits_left is 0 or a -(somthing) The full code I'm using is $query_ssl="select * from advertisers WHERE hits_left = '0'"; // query string stored in a variable $rt_ssl=mysql_query($query_ssl); while($nt_ssl=mysql_fetch_array($rt_ssl)){ @mysql_query("UPDATE advertisers SET ad_active = 'finished' WHERE site_url = '".$nt_ssl['site_url']."' AND username = '".$nt_ssl['username']."'"); } PHP:
Replace the first line with the line below. $query_ssl = 'SELECT * FROM advertisers WHERE hits_left <= 0'; Code (markup):