mysql_query and phpmyadmin result is different

[sniperscope]

Hello

I am facing this kind of problem first time in my life. After a search in google, i found that many people have same problem.

 

My sql query works at a.php but fail at b.php

I run same query in phpmyadmin gives me correct result.

 

a.php and b.php connecting database by using same include file.

 

cn.php

$cn	= mysql_connect("localhost", "username", "pass");
mysql_select_db("sdb", $cn);	
mysql_set_charset('utf8',$cn);

 

Here is my sql query:

 

include('inc/cn.php');
$sql = "SELECT COUNT(" .date("D"). ") AS total_user FROM staff WHERE " .date("D"). " != '～'";

[requinix]

Echo your queries and make sure they are what you think they are.

 

And wtf is with your table structure? Columns for each day of the week? That screams of an unnormalized database.

[sniperscope]

yes, columns for each day of the week.

Print echo that query and run it in the phpmyadmin returns data as i aspect(17 records).

But php pages bring entire staff.

[sniperscope]

Any help  please.

[derrck]

try to add `` on tablename

[sniperscope]

Thanks for reply.

I've just tested and no hope. Still same.

[derrck]

php and phpmyadmin are not same, you can try to set page and sql encoded

[sniperscope]

php and phpmyadmin are not same, you can try to set page and sql encoded

How this can be? Could you please little specific.

 

Regards

[requinix]

You are either (a) using the wrong server, (b) using the wrong database, © looking at the wrong file and code, and/or (d) running the wrong query.

[smoseley]

echo $sql;

[derrck]

php and phpmyadmin are not same, you can try to set page and sql encoded

How this can be? Could you please little specific.

 

Regards

 

three encoded need check:

file encoded

php encoded

mysql encoded

 

check file encoded first, you will see choose encoding when save as php file, choose UTF8

[sniperscope]

You are either (a) using the wrong server, (b) using the wrong database, © looking at the wrong file and code, and/or (d) running the wrong query.

 

Hello

 

(a) I am using correct server

(b) No i am not using wrong database because database connection is in inc/cn.php and all files in the site using that file for db connection

© No, I've checked maybe 50 times word by word for both query.

(d) No, I even copy entire query from working page to NON-working page. Same query fail

 

@smoseley:

Here is the result of echo: Resource id #3

 

I am facing this kind of weird problem first time in my life.

[xyph]

This is theoretically impossible, assuming it's the same query, run on the same server, using the same user and database. How would it execute differently on a different page through the same PHP parser? Assuming it runs at all, we know that isn't happening.

 

I haven't tested enough versions of phpMyAdmin, but I've used the heck out of the versions I have. I've never run into an issue where I copy working SQL to/from phpMyAdmin and it won't execute (assuming I wasn't giving it bad values in the first place).

 

This is a silly mistake on your end. Check the obvious places, cause it's going to be there.

[sniperscope]

 

three encoded need check:

file encoded

php encoded

mysql encoded

 

check file encoded first, you will see choose encoding when save as php file, choose UTF8

 

Dear derrck

You were right. I have checked file and php encoding.

 

Stupid guy who sitting next desk create file in Shift_JIS format and i didn't checked.

After your post, i have checked encoding and change into correct encoding. It is working now.

 

I really want to thank everyone who tried help me out. Without you guys probably i would have 2-3 more days headache.

 

Have a great days.