Search
Search

A query that uses variables works in PHPMyAdmin, but not in a PHP script

debugcn Published at Dev
14
user3887706

The following query returns the expected result when I use the SQL input box in PHPMyAdmin, however in a PHP MySQLi query ($sql->query()) an error occurs.

SET @a = 5;
SET @b = (SELECT `b` FROM `t` WHERE `c`=@a);
SELECT @b;

The error I get is:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET @b= (SELECT b FROM `t' at line 2

jeroen

You are doing 3 queries instead of 1 so you would need multi_query() instead of query().

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

A query that uses variables works in PHPMyAdmin, but not in a PHP script

From Dev

Query works in phpmyadmin but not in PHP

From Dev

MySQL query works in PHPMyAdmin but not PHP

From Dev

Mysql query works in Phpmyadmin but not works in PHP

From Dev

Query returns empty in script, works perfect in phpMyAdmin

From Dev

MySQL SELECT query works in PHPmyadmin, not in PHP

From Dev

MySQL INSERT query works in Phpmyadmin but not in PHP

From Dev

SQL Query works in phpMyAdmin but not in php page

From Dev

mysql query works in phpmyadmin but errors in php

From Dev

How can I get a mysql script that works in PHPmyadmin, to work in a PHP mysql query?

From Dev

DB query from PHP gives no result but same query on phpMyAdmin works?

From Dev

PHP MYSQL query won't work in PHP but works in PHPMyAdmin

From Dev

mysql and php %like% query. Works in phpmyadmin but different results php

From Dev

MySQL works in terminal on PHPmyadmin but does not work in php script?

From Dev

Insert query works on phpMyAdmin but not with Java

From Dev

MySQL query's suceed in PHPMyAdmin but not in the PHP Script itself

From Dev

MySQL UPDATE works in phpMyAdmin but not in PHP

From Dev

PHP Login script with ajax works but session variables do not exist

From Dev

Query works perfect in phpmyadmin but only returns true/1 when fetching with php

From Dev

mysql query works in phpmyadmin but not in node.js

From Dev

MySQL Query Not Working Live But Works In PHPMyAdmin

From Dev

Scheduling php script in phpMyAdmin 3.3.8.1

From Dev

SQL query working in phpmyadmin but not in php

From Dev

PHP and MySQL french accent works in PHPMyAdmin but not in page

From Dev

Query works in sql but not in php

From Dev

mysql "between date" query works in phpmyadmin but returns nothing with PDO

From Dev

MySQL query runs ok in phpMyAdmin but hangs in PHP

From Dev

MySQL query working in PHPMyAdmin but not working in PHP

From Dev

PHP SQL query not returning same rows as in phpMyAdmin

Related Related

  1. 1

    A query that uses variables works in PHPMyAdmin, but not in a PHP script

  2. 2

    Query works in phpmyadmin but not in PHP

  3. 3

    MySQL query works in PHPMyAdmin but not PHP

  4. 4

    Mysql query works in Phpmyadmin but not works in PHP

  5. 5

    Query returns empty in script, works perfect in phpMyAdmin

  6. 6

    MySQL SELECT query works in PHPmyadmin, not in PHP

  7. 7

    MySQL INSERT query works in Phpmyadmin but not in PHP

  8. 8

    SQL Query works in phpMyAdmin but not in php page

  9. 9

    mysql query works in phpmyadmin but errors in php

  10. 10

    How can I get a mysql script that works in PHPmyadmin, to work in a PHP mysql query?

  11. 11

    DB query from PHP gives no result but same query on phpMyAdmin works?

  12. 12

    PHP MYSQL query won't work in PHP but works in PHPMyAdmin

  13. 13

    mysql and php %like% query. Works in phpmyadmin but different results php

  14. 14

    MySQL works in terminal on PHPmyadmin but does not work in php script?

  15. 15

    Insert query works on phpMyAdmin but not with Java

  16. 16

    MySQL query's suceed in PHPMyAdmin but not in the PHP Script itself

  17. 17

    MySQL UPDATE works in phpMyAdmin but not in PHP

  18. 18

    PHP Login script with ajax works but session variables do not exist

  19. 19

    Query works perfect in phpmyadmin but only returns true/1 when fetching with php

  20. 20

    mysql query works in phpmyadmin but not in node.js

  21. 21

    MySQL Query Not Working Live But Works In PHPMyAdmin

  22. 22

    Scheduling php script in phpMyAdmin 3.3.8.1

  23. 23

    SQL query working in phpmyadmin but not in php

  24. 24

    PHP and MySQL french accent works in PHPMyAdmin but not in page

  25. 25

    Query works in sql but not in php

  26. 26

    mysql "between date" query works in phpmyadmin but returns nothing with PDO

  27. 27

    MySQL query runs ok in phpMyAdmin but hangs in PHP

  28. 28

    MySQL query working in PHPMyAdmin but not working in PHP

  29. 29

    PHP SQL query not returning same rows as in phpMyAdmin

HotTag

Archive