how can i use two mysql query with user defined variable in php

Question

select @min_price:=min(prd_sale_price),@max_price:=max(prd_sale_price) from ct_product;
select * from ct_product where prd_sale_price=@min_price or prd_sale_price=@max_price;

This query works in mysql console

but

$query = "
select @min_price:=min(prd_sale_price),@max_price:=max(prd_sale_price) from ct_product;
select * from ct_product where prd_sale_price=@min_price or prd_sale_price=@max_price;
";

$result = mysql_query($query);

this code raise error in php

so, I tried this

$query="
select * from ct_product, (select @min_price:=min(prd_sale_price),@max_price:=max   (prd_sale_price) from ct_product) as b 
where prd_sale_price=@min_price or prd_sale_price=@max_price
";

$result = mysql_query($query);

that works

...

$query = "
select @min_price:=min(prd_sale_price),@max_price:=max(prd_sale_price) from ct_product;
select * from ct_product where prd_sale_price=@min_price or prd_sale_price=@max_price;
";

$result = mysql_query($query);

What's the way that this code would work well without modification as my second way?

Any reason you can't use some flavor of join in your query? As Dagon says, mysql_query will only take one query for one result. — Zarathuztra
– Zarathuztra, Commented Dec 10, 2013 at 2:34

Barmar · Accepted Answer · 2013-12-10 02:34:42Z

4

Use two calls to mysql_query:

$query1 = "select @min_price:=min(prd_sale_price),@max_price:=max(prd_sale_price) from ct_product";
$query2 = "select * from ct_product where prd_sale_price=@min_price or prd_sale_price=@max_price";

mysql_query($query1);
mysql_query($query2);

Variables are associated with a database connection, so they'll persist between the calls.

answered Dec 10, 2013 at 2:34

Barmar

789k57 gold badges554 silver badges669 bronze badges

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

1 Comment

subzero Over a year ago

Thank you for your answer.. i try and your code work very well

Yehia Awad · Accepted Answer · 2013-12-10 02:37:14Z

0

in PHP mysql_query() can handle only one query at a time

You can't make this method handle 2 query at the same time

what I can suggest is using mysql_query() for every query

answered Dec 10, 2013 at 2:37

Yehia Awad

2,9961 gold badge22 silver badges31 bronze badges

Collectives™ on Stack Overflow

how can i use two mysql query with user defined variable in php

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related