Gazz1982 Posted June 9, 2008 Share Posted June 9, 2008 hi I'm using: $result = mysql_query("SELECT * FROM login order by EMAIL") I want to select * except where column = admin how do I alter this? Thanks Link to comment https://forums.phpfreaks.com/topic/109464-solved-select-this-but-not-that/ Share on other sites More sharing options...
revraz Posted June 9, 2008 Share Posted June 9, 2008 Adding this should do it. WHERE column != 'admin' Link to comment https://forums.phpfreaks.com/topic/109464-solved-select-this-but-not-that/#findComment-561487 Share on other sites More sharing options...
Gazz1982 Posted June 9, 2008 Author Share Posted June 9, 2008 Thanks - I just figured it out myself - I'm rusty! Link to comment https://forums.phpfreaks.com/topic/109464-solved-select-this-but-not-that/#findComment-561490 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.