mysqli_query returns false for some queries

Asked Dec 07 '17 at 18:11

Active Dec 07 '17 at 20:10

Viewed 39 times

I am facing a real weird problem. Mysqli_query works fine in my localhost but not on the server. These are the following things I have checked -

Php version. My localhost php version is 5.6 and even my server's php version is 5.6.
I checked whether the query is generated properly. The query for which I am getting false as the result is as follows :-

$qquery = "select uniqueID,question,emailgroup,email,if_read from 
  expert_questions where id=$id;";

which generates the following query after echo :-

select uniqueID,question,emailgroup,email,if_read from expert_questions where id=955;

Now this query, executes totally fine in the localhost and gives me perfect results in the localhost. Also I tried to execute this query in the server's database, it gives me output too.

I also checked whether the php files are not having mysql_connect commands, and it did have them. So I changed the whole code mysql improvised version.

The weirdest problem is that, that particular query works totally fine for ids less than 900. But it does not work for ids greater than 900 as I showed above about id=955. Please help me out. Thank you.

edited Dec 07 '17 at 20:10

jasinth premkumar

1,430
1
12
22

asked Dec 07 '17 at 18:11

Krish Bhanushali

See [`mysqli_error()`](http://php.net/manual/en/mysqli.error.php). – Alex Howansky Dec 07 '17 at 18:13
mysqli_error() returns true everytime. – Krish Bhanushali Dec 07 '17 at 18:14
No. It returns a string. – Alex Howansky Dec 07 '17 at 18:15
@KrishBhanushali: Eh? It returns mysqli error, or empty string. Not `true`. When `mysqli_query` returns `false`, it means that you have error in your query. Eg. missing ID. – pavel Dec 07 '17 at 18:15
I am sorry. It returns null. – Krish Bhanushali Dec 07 '17 at 18:16
@KrishBhanushali: Not null, maybe empty string. But if `error` returns empty string, `mysqli_query` can't return `false`. – pavel Dec 07 '17 at 18:17
Yes it giving me an empty string. But if I execute the same generated query in sequelPro it gives me an output. – Krish Bhanushali Dec 07 '17 at 18:20
@KrishBhanushali: so the query is fine and you have problem elsewhere. Check the error log. – pavel Dec 07 '17 at 18:22
No errors in the error log. It is so weird. – Krish Bhanushali Dec 07 '17 at 18:24

mysqli_query returns false for some queries

0 Answers0