Using a query on a query (or view)

[John Victor]

In my php page I'm using a mysql database. I want to run a query on a
table, then run a second query on the results returned from the first query.
In mysql this would be the same as running a query on a table to create a
view, and then running a query on the resulting view. What is the php
equivalent of this?

Thanks.


--
John

[Michael Austin]

John Victor wrote:

In my php page I'm using a mysql database. I want to run a query on a
table, then run a second query on the results returned from the first query.
In mysql this would be the same as running a query on a table to create a
view, and then running a query on the resulting view. What is the php
equivalent of this?

looping through the results looking for the results you expect.

look at preg_match and related string matching functions.

Or if you are using MySQL 5.0.0.1 then you can actually create and use a view.

--
Michael Austin.
Consultant - Available.
Donations welcomed. Http://www.firstdbasource.com/donations.html
:)

[chotiwallah]

"John Victor" <wi******@pacbe ll.net> wrote in message news:<Pv******* **********@news svr21.news.prod igy.com>...

In my php page I'm using a mysql database. I want to run a query on a
table, then run a second query on the results returned from the first query.
In mysql this would be the same as running a query on a table to create a
view, and then running a query on the resulting view. What is the php
equivalent of this?

Thanks.

you could create a temporary table from your 1st query and use that like a view.
see http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html

micha

[John Victor]

Unfortunately, I have to use MySQL 4.x

John
"Michael Austin" <ma*****@firstd basource.com> wrote in message
news:Lu******** *********@newss vr24.news.prodi gy.com...

Or if you are using MySQL 5.0.0.1 then you can actually create and use a view.
--
Michael Austin.
Consultant - Available.
Donations welcomed. Http://www.firstdbasource.com/donations.html
:)

[Mark Kuiphuis]

<?php
$query = "SELECT id FROM table";
$result = mysql_query($qu ery);
if ($result) {
while ($r = mysql_fetch_arr ay($result) {
$id = $r["id"];

$query2 = "SELECT * FROM otherTable where id = '$id'";
$result2 = mysql_query($qu ery2);
if ($result) {
while ($r2 = mysql_fetch_arr ay($result2) {
$colfrom2ndtabl e = $r2["name"];
}
}
}
}
?>

Regards....

Mark

Another way is to put the results of $result in an array. Then (outside
the while-loop) do a for-loop and wlak through the results in the array
and use the id.
John Victor wrote:

In my php page I'm using a mysql database. I want to run a query on a
table, then run a second query on the results returned from the first query.
In mysql this would be the same as running a query on a table to create a
view, and then running a query on the resulting view. What is the php
equivalent of this?

Thanks.