while loop inside a for loop

[planetphp]

Hi,

I'm trying to query a table and then query a few rows of another table, but the second while loop returns

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/sites/site11/web/panel/func_orders.php on line 103

what am i doing wrong...

Thanks in advance!

	$items_query = "select * from order_items where ordernum = '$orderNum'";
	$items_result = mysql_query($items_query);
	while($items_data = mysql_fetch_array($items_result)){
		$item[] = $items_data[1];
		$tref[] = $items_data[2];
		$size[] = $items_data[3];
		$gallery[] = $items_data[4];
	}

	for ($i = 0; $i < count($size); $i++) {

	if($size[$i] == "S"){ $fsize = "small"; }
	elseif($size[$i] == "M"){ $fsize = "medium"; }
	elseif($size[$i] == "L"){ $fsize = "large"; }
	elseif($size[$i] == "XL"){ $fsize = "xlarge"; }
	elseif($size[$i] == "XXL"){ $fsize = "xxlarge"; }

	$stock_query = "select $fsize from dis_$gallery[$i] where Tref = '$tref[$i]'";
	$stock_result = mysql_query($stock_query);
		while($stock_data = mysql_fetch_row($stock_result)){
			$number = $stock_data[0];
			echo "$item - $tref: $number in stock";
		}
}

[devinemke]

$stock_query = "select $fsize from dis$gallery[$i] where Tref = '$tref[$i]'";

you are sure that the variables $fsize and dis$gallery[$i] are valid fieldname/tablename?

[kevinsequeira]

can u print $stock_query and see what the output is ?

[planetphp]

doh.... i was querying the wrong table... spent 3 f**king hours trying to figure that out...

time to go home to bed me thinks!!

Thanks for your help!

[troublemaker]

Quick first look...

I am not sure where your problem starts, but you execute a "mysql_fetch_array" after the first query for the while loop, and then you execute a "mysql_fetch_row" for the second query's while loop?

?????