2 queries at a time

[SyLon]

Hello every one.

How can I get a result based on multiple  queries?

For example:

query 1:

select * from users where user_id=3346

query 2:

select * from users where reg_date=$time

 

I would like to receive a result similar to the result I would get if I would run this query:

select * from users where user_id=3346 AND reg_date=$time

 

Is that possible?

Thanks in advance, Leon.

[Ken2k7]

Hello every one.

How can I get a result based on multiple  queries?

For example:

query 1:

select * from users where user_id=3346

query 2:

select * from users where reg_date=$time

 

I would like to receive a result similar to the result I would get if I would run this query:

select * from users where user_id=3346 AND reg_date=$time

 

Is that possible?

Thanks in advance, Leon.

<?php
mysql_query("select * from users where user_id='3346' AND reg_date='$time'") or die(mysql_error());
?>

 

That should work.

[SyLon]

I know it would work.

But I need to get a result based on TWO queries at a time.

Let's say I have 2 vars: $q1 and $q2. Each contains a query.

I want to run them both and get ONE result based on those queries.

Theoretically something like this:

mysql_query($q1,$q2) or die(mysql_error());

The result I would get will mach the two queries $q1 and $q2.

I hope its clear now.

Thanks.

[redbullmarky]

would UNION be what you're after?

[SyLon]

Exactly!

Thanks!