Query within a Query

[BulldogGC]

$execute = mysql_query("SELECT * FROM servers_games ORDER BY name");
	while($row = mysql_fetch_array($execute)) {
		$servers = mysql_query("SELECT * FROM servers_information WHERE gameid = $row[id]");
			while($row_servers = mysql_fetch_array($servers)) {

		}
}

Something so simple, yet I've never ran across it before ... any help would be appreciated.

And the SQL statement itself is fine, that isn't what is throwing off the error.

[LordShryku]

Yeah....so......what is the error?

[BulldogGC]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

It's saying that SECOND MySQL statement is not valid.

It's not recognizing the $row[id] as being valid.

If you run the query with just an actual number in it OUTSIDE the first query it works fine.
And $row[id] does exist.

[LordShryku]

Well, just to take a stab at your current code, try changing that query to this:

$servers = mysql_query("SELECT * FROM servers_information WHERE gameid = '".$row['id']."'");

I am thinking you could do this all in one query though

[BulldogGC]

Yeah, it did lie in that line --

$servers = mysql_query("SELECT id,name,ip FROM servers_information WHERE gameid = ".$row[id]);

is what I ended up using.

thanks!

[unstable_geek]

you might want to look at streamlining this with one SQL query:

select * from servers_information where gameid = (select id from servers_games order by name)