[RESOLVED] How to Query a Query

kmark

Hi,

I was wondering if it possible to query a query with PHP. I have done it in coldfusion but have not found a way to do it with PHP.

Any help would be appreciated.

Thanks,

Mark

thorpe

What exactly do you meen? You'll ned to explain it a bit better I'm afraid.

Do you meen run a query based on the results of another?

kmark

Sorry let me explain a bit more.

$sql = "SELECT * FROM `tblmembers` WHERE `emgolf` = 'yes' OR `emtennis` = 'yes' OR `emswimming` = 'yes' OR `emsocial` = 'yes'";
$result = mysql_query($sql);

Now that I have those result I want to run a query on them like this except one that works:

$sqlx = "SELECT * FROM `[B]queryname[/B]` WHERE `membernumber` like '1%' OR `membernumber` like '4%' OR `membernumber` like '9%'";

I hope this makes it clearer.

Let me know...

frost110

Wow dude look at what coldfusion has done to you. Made you incapable of explaining something clearly LMAO!! GO PHP

At anyrate. I am not sure what you are saying but maybe this will clear it up:

$sql = "SELECT * FROM `tblmembers` WHERE `emgolf` = 'yes' OR `emtennis` = 'yes' OR `emswimming` = 'yes' OR `emsocial` = 'yes'";
$result = mysql_query($sql); 

while ($row = mysql_fetch_assoc($result)) {
	 $memNumbs = $row['membernumber'] . ", ";
}

$memNumbs = substr_replace($memNumbs, "", -2, 1);

$sqlx = "SELECT * FROM `tablename` WHERE `membernumber` IN(".$memNumbs.")";

Hope that helps, if not attempt to explain it clearer please.

--FrosT

Roger_Ramjet

Which should be done in SQL with 1 query.

With sub-query support in your version

$query = "SELECT * FROM (SELECT * FROM tblmembers WHERE emgolf = 'yes' OR emtennis = 'yes' OR emswimming = 'yes' OR emsocial = 'yes') AS t WHERE membernumber like '1%' OR membernumber like '4%' OR membernumber like '9%'";

Couls also use the sub-query in the WHERE clause instead of the FROM clause.

But this is not neccessary with your example anyway

$query = "SELECT * FROM tblmembers WHERE (emgolf = 'yes' OR emtennis = 'yes' OR emswimming = 'yes' OR emsocial = 'yes') AND (membernumber like '1%' OR membernumber like '4%' OR membernumber like '9%')";

And most sub-query queries can be re-written using joins instead.

And loose the back-ticks around your table and column names, makes me shudder. They are only needed when you are using non-standard names, and you should never use reserved words or non-standard names so you should never need the back-ticks.

kmark

Thanks Guys I went with the last suggestion there and it works great

$sql = "SELECT * FROM tblmembers WHERE (condition OR condition)AND(more conditions OR more conditions)";

Also thanks for the tip RE: tick marks good to know.

-Mark