php - comparing resultsets

toString

toString

toString

Soldato
Joined
18 Oct 2002
Posts
9,065
Location
London
Having yet more php troubles (it never seems to end)...

Code: 
while ($row = mysql_fetch_row($rs_full)) {
	while ($row2 = mysql_fetch_row($rs_selected)) {
		if ($row[0] == $row2[0]) {
			echo "$row2[1]";
		}	
	}
}

Should something like that work? I'm finding it doesn't, at all. Am I doing something wrong? It *looks* right, (to me at least)..

$rs_selected is a subset of $rs_full.
 
No ideas php gods? :eek:

I'll tell you what does happen, it cycles through all 30 of $rs_full.
But it will only print out the first result from $rs_selected and that's it. It never prints out the 2nd, 3rd, etc. Even though there is a few more results.

It'd be alright if I could see something wrong, I could then work out how to fix it, but I don't know what is wrong which makes it frustrating :o
 
Sounds like an idea, but I'm not sure if it's possible with my queries:

Code: 
$full_q = "SELECT CatID, CatName FROM category";
$rs_full = mysql_query($full_q);

$selected_q = "SELECT CatID, CatName
	FROM category
	WHERE CatID IN (SELECT CatID FROM product_category WHERE ProductID=".getInput($_GET['id']).")";
$rs_selected = mysql_query($selected_q);

I need the full listing of categories, but at the same time I need to know which of these categories are selected in the 'product_category' table.
 
You must log in or register to reply here.
Back
Top Bottom