where join help!

[Anon]

hi everyone, i have this problem. i have a table called bitlog it has 2 fields "cookies" & "refere". i do a while loop to get what cookies visited given url like this:

$url=mysite.com/blabla.html;
$sql="select cookies, refere from bitlog where refere='$url'";

while ($row = mysql_fetch_array($result)) {
$cookies = $row['cookies'];
$text="$cookies";
}

now comes the problem: i also need to find out what kind of other url did $cookies stored now in $text visited (urls are in refere field). how can i do this 2 together.

Regards
Arman Galstyan
eNotalone.com inc.

[[deleted]]

First, this makes no sense:

$cookies = $row['cookies'];
$text="$cookies";

you can just do this instead:
$text = $row['cookies'];

The simplest method to get what you want is to run a new query for every $text value you find with the first query.

you'd get something like this:

$sql="select cookies, refere from bitlog where refere='$url'";

while ($row = mysql_fetch_array($result))
{
$text = $row['cookies'];
$sql2 = "SELECT refere FROM bitlog WHERE cookies ='$text'";
$result2 = mysql_query($sql2);
while ($row2 = mysql_fetch_array($result2))
{
echo $row['refere'];
}
}

A more comples method involves a JOIN between the table and a copy of itself.
But that gives all the results in one large set, and you have to filter them manually.

[Anon]

dear vincent, thank you for the tip, works fine and is exactly what i needed. thanks again. arman