neller Posted January 13, 2010 Share Posted January 13, 2010 I have read the stickies and searched other threads but can't seem to find an answer, have not seen these in any of my mysql books either. If you had this Query..... SELECT DISTINCT ehorsename FROM entries WHERE rraceid = '1' AND ehorsename <> 'Horse Name' AND eprognum <> '' AND eprognum <> '0' What are the <> doing? I'm used to using them for "less than" or "greater than" but they are clearly not being used for this here, when used together do they mean something else? thanks Link to comment https://forums.phpfreaks.com/topic/188381-queries-using/ Share on other sites More sharing options...
salathe Posted January 13, 2010 Share Posted January 13, 2010 It simply means "not equal", in MySQL it is the same as "!=". Link to comment https://forums.phpfreaks.com/topic/188381-queries-using/#findComment-994503 Share on other sites More sharing options...
ignace Posted January 14, 2010 Share Posted January 14, 2010 in MySQL, I thought they were the same in PHP to, are they not? Link to comment https://forums.phpfreaks.com/topic/188381-queries-using/#findComment-994827 Share on other sites More sharing options...
salathe Posted January 14, 2010 Share Posted January 14, 2010 ignace, <> is not a PHP operator. Link to comment https://forums.phpfreaks.com/topic/188381-queries-using/#findComment-994869 Share on other sites More sharing options...
ignace Posted January 14, 2010 Share Posted January 14, 2010 ignace, <> is not a PHP operator. http://www.php.net/manual/en/language.operators.comparison.php, are you sure? Link to comment https://forums.phpfreaks.com/topic/188381-queries-using/#findComment-994937 Share on other sites More sharing options...
salathe Posted January 14, 2010 Share Posted January 14, 2010 Heh, my mistake. Though I can honestly say, I've never used it... always != Link to comment https://forums.phpfreaks.com/topic/188381-queries-using/#findComment-994939 Share on other sites More sharing options...
ignace Posted January 14, 2010 Share Posted January 14, 2010 Heh, my mistake. Though I can honestly say, I've never used it... always != Though I must say that because of your rep. my first thought was that they removed it and had to look it up to be sure Link to comment https://forums.phpfreaks.com/topic/188381-queries-using/#findComment-994951 Share on other sites More sharing options...
salathe Posted January 14, 2010 Share Posted January 14, 2010 Though I must say that because of your rep. my first thought was that they removed it and had to look it up to be sure I have a rep? Anyway, it is indeed good to always take a peek at the manual for the authority on things (and if the manual is wrong, file a bug report!). It is often my first port of call when answering a question (but shh, I'm giving away my secrets to answering Qs!). Link to comment https://forums.phpfreaks.com/topic/188381-queries-using/#findComment-994975 Share on other sites More sharing options...
ignace Posted January 14, 2010 Share Posted January 14, 2010 I have a rep? Yeah unless they give those @php.net e-mails away for free?!? Plus your recent Guru promotion means your words have a much higher-value then if some john doe said something, like me . It is often my first port of call when answering a question (but shh, I'm giving away my secrets to answering Qs!) I believe this is everyone's secret I already got the manual on speed dial Plus because of the authority the PHP manual has on Google it' easy for me to just type: php some_function In my Firefox URL address bar which is the same as I'm feeling lucky on Google search add in a nice add-on and you can just type the function name in the upper right search bar of Firefox, what's not to like? PHP Manual ROCKS!! Link to comment https://forums.phpfreaks.com/topic/188381-queries-using/#findComment-994977 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.