Seitan Posted December 10, 2006 Share Posted December 10, 2006 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? Link to comment https://forums.phpfreaks.com/topic/30170-having-a-problem-with-a-statement/ Share on other sites More sharing options...
btherl Posted December 11, 2006 Share Posted December 11, 2006 Try adding ua.approved into the select list (ie, the results of the query) and see what you end up with. Link to comment https://forums.phpfreaks.com/topic/30170-having-a-problem-with-a-statement/#findComment-138848 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.