Help me understand why my query doesn't work the way I think it should

[phporcaffeine]

QUERY:

mysql_query(SELECT ad_meta.*, tracking.views, tracking.clicks FROM ad_meta, tracking WHERE tracking.better_id = ad_meta.better_id AND ad_meta.better_id='" . $temp[0] . "' LIMIT 200");

 

Now the query does select by the criteria I want it to but it seems to ignore the LIMIT clause and returns many more rows than the 200 threshold I want.  Please tell me what I am doing wrong?

 

-TIA

[fenway]

That seems impossible... echo this string.

[phporcaffeine]

The query does in-fact work, it just returns all rows instead of respecting the limit clause.  My only other solution I guess is a staged query

[fenway]

The query does in-fact work, it just returns all rows instead of respecting the limit clause.  My only other solution I guess is a staged query

I never said it didn't work.  But your quoting is all funny, so pls show us the actual sql query issued to the server.