MySQL query working in phpmyadmin but not in PHP

Question

i've created a mysql view which is expecting 2 parameters and i'm able to query it without problems in phpyadmin with the following sql-string:

SET @date1 = '2014-02-06'; 
SET @date2 = '2014-02-07'; 
SELECT * FROM _myquery

it will not work under php - i'm getting the following error:

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 @date2 = '2014-02-07'; SELECT * FROM _myquery' at line 2

when it's working in phpmyadmin, shouldn't it also work under php? any idea what's wrong?

You can probably only run 1 statement at a time, you have 3. — jeroen
– jeroen, Commented Feb 6, 2014 at 0:21
As jeroen said, you can only run one at a time. But what's the point of setting variables you aren't using anyway? — developerwjk
– developerwjk, Commented Feb 6, 2014 at 0:27

Community · Accepted Answer · 2017-05-23 10:25:57Z

1

Do you really need the MySQL variables? because your SELECT query is not using them. You can try just with

SELECT * FROM _myquery

But if you really need to use MySQL variables, take a look at this:

Mysql Variables not working through php mysql query

MySql variables and php

edited May 23, 2017 at 10:25

CommunityBot

11 silver badge

answered Feb 6, 2014 at 0:28

Lordn__n

3282 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL query working in phpmyadmin but not in PHP

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related