Oh crap, someone mailed me about having nulls in my field compared...
you can no disregard this thread...its closed i got the culprit, it's a
stupid NULL i found in a column
"Mathieu Dumoulin" <[EMAIL PROTECTED]> a écrit dans le message de
news: [EMAIL PROTECTED]
> More info on this problem, i tried running the queries (the NOT IN and the
> IN) while TRIM() the field compared just to see and i did that in a web
> page directly thru the mysql<=>php api.
> Trimming and using in list: 6286
> Trimming and using not in list: 7
> Not trimming and using in list: 6286
> Not trimming and using not in list: 7
> So no change...
> This seems to be a bug in mysql...
> Mathieu Dumoulin
> "Mathieu Dumoulin" <[EMAIL PROTECTED]> a écrit dans le message de
> news: [EMAIL PROTECTED]
> > Hi there, want to say this right off the start the calculations here are
> > used with the totals of the results and not the range so dont go telling
> > that i might have used a 0 based index, NO...
> > I have 6294 lines in my table
> > i query with a IN (...) statement and i get 6286 lines out of my DB
> > i query again using the same list but with NOT IN (...) and i get 7
> > Theoricaly, i should get all lines thru this way of doing right? Well
> > 6286+7 = 6293
> > Where is my last line??? Could this be a bug in the IN, NOT IN
> > mysql? or is this part of a problem related to phpMyAdmin? I will try to
> > these queries right off a web page using the direct api to the mysql
> > database to see if it's in phpMyAdmin or mysql, till then i hope someone
> > find something wrong in my doing, it's only logical that i should get
> > lines!!!
> > Mathieu
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php