Mysql select giving the wrong answer inside php

Question

I have this issue with a PHP script when querying a mysql DB.

The query is:

SELECT COUNT(*) FROM theTable WHERE fieldValue = ‘Dom-Rémy'

I have checked that when performing by hand this query in the administration console (phpMyAdmin) I can find one record matching the request, which is what I expect.

But inside a PHP script where the code is as follows, I always get 0 records (instead of 1):

$Query = "SELECT COUNT(*) FROM theTable WHERE fieldValue = 'Dom-Rémy'";
$DBR = mysql_query($Query,$Connection);
$NBR = mysql_result($DBR,0,0);
printf("NBR: %d\n",$NBR);

Why is that? I suspect the european character inside the fieldValue is what causes the problem, but what should I do to make it work?

You suspect the european character inside the fieldValue causes the problem. That's easy to test. Have you done that? — KIKO Software, Aug 10 '16 at 07:58
use mysql_real_escape_string('Dom-Rémy') before passing to sql query — Aman Maurya, Aug 10 '16 at 08:00
Do not use the `mysql_*` API in PHP; switch to `mysqli_*` or `PDO`. — Rick James, Aug 13 '16 at 01:50

score 1 · Accepted Answer · answered Aug 10 '16 at 07:56

1

Using something like this before Your query to set charset of client and results:

  mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'", $conn);

answered Aug 10 '16 at 07:56

Whencesoever

2,218
15
26

Simpler is to execute `SET NAMES ut8`. – Rick James Aug 13 '16 at 01:50

score -1 · Answer 2 · answered Aug 10 '16 at 07:57

-1

Use only count count(*) wont work some time

$query = "SELECT COUNT FROM theTable WHERE fieldValue = 'Dom-Rémy'";
 $result = mysql_query($query);

answered Aug 10 '16 at 07:57

rupesh

277
3
15

It is count() function. Count is nothing. – Steve Sep 19 '16 at 06:49

Mysql select giving the wrong answer inside php

2 Answers2

Linked