Help...! (Sub Query)

[nadnakinam]

hi to all,

this might be very simple, but i don;t know how to get correct output, someone help me to complete it...

1st i need to get result from this query

$sql="SELECT * FROM $tbl1_name WHERE sex='$show_all'";
$result=mysql_query($sql);

this'll result either all the boys or all the girls;

from the above result again i need select according to their age using this 2nd query.

$sql="SELECT * FROM $tbl1_name WHERE age BETWEEN '$from' AND '$to'";
$result=mysql_query($sql);

Help me to do this in single subquery...

Thanx in advance...

[pritaeas]

$sql="SELECT * FROM $tbl1_name WHERE sex='$show_all' AND age BETWEEN '$from' AND '$to'";

[pritaeas]

Duplicate again.

[baki100]

SELECT  * 
FROM $tbl1_name 
WHERE age BETWEEN '$from' AND '$to'
AND sex='$show_all'

[nadnakinam]

U done it again Pritaeas...!
Thank You...

[nadnakinam]

i done like this,

$sql="SELECT * FROM $tbl1_name WHERE username='$name' IN (SELECT * FROM $tbl1_name WHERE sex=$sex01)";
$result=mysql_query($sql);

I knew it is not better than yours, Pritaeas...
is it right way?

[pritaeas]

That is not a valid query, but I am unsure of what you want to achieve.

[baki100]

that's horribly inefficient using an inner select on the same table

[network18]

why to complicate the simple query, he just have two simple reuirements on the same table as -
1)age BETWEEN something AND something
and 2)sex as all on same table

SELECT * FROM $tbl1_name WHERE sex='$show_all and age BETWEEN '$from' AND '$to'

It aslo depends upon what you pass as in $from and $to

[nadnakinam]

You are right, its better to not to get complicated...

Thank You for All those who replied...