Php And phpmyadmin are not returning the same results

perrohunter

Hi !

I have this huge huge table with about 1,306,129 rows. Im trying to get query results faster as I can so I came up with the idea that selecting a fields using DISTINCT() would improve the speed, and so it did, when i run the query on phpmyadmin it returns considerably faster (only distints duu) than usual query.

So the problem comes when I try to use the same query on PHP , it is just not working
what im executing is

on phpmyadmin : SELECT DISTINCT(field),field2,field3 FROM table WHERE field2='x'
and this returns 11 results

on PHP: mysql_query("SELECT DISTINCT(field),field2,field3 FROM table WHERE field2='x'");
and this returns 2040 results

Anyone has an idea whats happening ??

sid

are you sure you are querying the same database/table in both environments?

i troubleshoot queries usually by keeping them in a variable ($q for example) and echoing it out, along with the execution of the mysql_query($q) command. then you can just copy & paste it into phpmysql and see if you still get different results (which you shouldnt).

NogDog

While I don't think this has a direct bearing on your question, to the best of my knowledge DISTINCT is always a stand-alone keyword which affects the SELECT; it is not a function. Therefore the parentheses around the field name which follows it are meaningless.

perrohunter

Most of the time that I use DISTINCT is as a function , or at least thats how ive learned, im trying to get differents field1, however I also need the field2 and field3 as they are on the table =(

Any other idea or how could i fix that ?

I thought that i could distint only field1, and then select where field1="results from distinct"

i dont know =P

Weedpacket

perrohunter wrote:
differents field1, however I also need the field2 and field3 as they are on the table =(

You don't need to select them if you don't want to use them. Besides, what should be returned if you have two records with different values for field3 (there's no point asking about field2, you already know the value of field2) but the same value for field1?

perrohunter

well suppouse i dont want the WHERE clause, cuz i already know it, but i want the fields that are aside of my different "fields2" results ={

as22607

perrohunter wrote:
well suppouse i dont want the WHERE clause, cuz i already know it, but i want the fields that are aside of my different "fields2" results ={

can you give me your sql structure please?

as sometimes its to do with the acutally type of data and since phpmyadmin knows what it playing with and your php code doesnt it might be to do with that and it a simple as rmeoving ''