mysql_query into array...

[Anon]

Hi!

I'm trying to put the results of some query's I'm doing in an array. But PHP seems not to like that, it returns false. When I store the result in a normal var it works, but it's not really an option to use normal var's all over my program. To clarify : Here's some code that's like mine :

==========MY INVALID CODE==================
// This is the wrong code...

$Result[0] = (mysql_query("SELECT * from table"));

==========MY VALID CODE====================
// This is the working version, without
// an array...

$Result = (mysql_query("SELECT * from table");

Thanks for helping!!!

[Anon]

First of all, those extra () around the mysql_query call look a bit suspect, in my opinion.

Secondly, mysql_query returns a result set identifier, which has to be examined with mysql_result(), mysql_fetch_array() or suchlike to get the contents of each field. Is it the result set identifier you want to store? How many queries are you doing?

If you are wanting to do what it looks like you're doing, and PHP really doesn't allow you to store resultsets in arrays, consider the possibility of using variable variables instead. Then you can have variables $Result0, $Result1, $Result2, .... and loop through them with something like

for($i=0; $i<$numresultsets; ++$i)
{
...
$row = mysql_fetch_array(${'Result'.$i});
...
}

For more on variable variables, see

http://www.php.net/manual/en/language.variables.variable.php

[Anon]

Thanx for the tips. It's solved!