query in a loop

[Tiger99]

Hi i am wondering is it legal to have a query while fetching another query? Because when I run the following code, it doesn't do anything

eg
while($row = @mysql_fetch_array($result)){

		$query2 = "select name from artist where id='$row[id]'";
		if(!($result2 = @mysql_query($query2, $conn))){
			die("Can't Query");
		}
		$row2 = @mysql_fetsh_array($result2);
		$info.="<td>$row2[name]</td>";
	}

Please help

Thanks in advance

[herve]

Hi,

check the $query2 content;

I think you should use :

$query2 = "select name from artist where id='".$row[id]."'";

otherwise the ' ' disable the interpretation
of $row[id] ; also, shouldn't it be $row["id"] ?

Regards,
Hervé.

[run2web]

It appears to me that this statement:

while($row = @mysql_fetch_array($result)){

should be

while($row = @mysql_fetch_array($result, result2)){

I'm a NooB so I could be wrong and please someone correct me if I am. 🙂

[Tiger99]

I don't think that's the problem because I use '$row[id]' throughout my script and all of them work.
After I change my code as you suggested. It gives me a parse error

I know I can always assign the values of $row[id] into an array and then use foreach to assign the value to the query, but that's just stupid

Anymore Idea?

Thanks for help

[Tiger99]

oops spelling error
it works now

Thanks