having a problem with a statement

[Seitan]

Im trying to display all the links that aren't approved. This is what I have

[code]"SELECT u.url_id, url, title, description FROM urls AS u, url_associations AS ua WHERE
u.url_id = ua.url_id AND ua.approved = 'N' ORDER BY date_submitted DESC";[/code]

Unfortunately it displays [b]all[/b] the links. can someone help?

[btherl]

Try adding ua.approved into the select list (ie, the results of the query) and see what you end up with.