$result = mysql_fetch_array($query);

carrie

I got this script that i'm trying to run. It takes character information from a game and is supposed to make a heirarchy tree with everyone's stats.

The setup creates all the tables for me, but when i attempt to run the setup it gives me this error:

Warning: Supplied argument is not a valid MySQL result resource in /www/chroniclesoftao.org/html/tree/boardprefs.php on line 4

the line it's talking about from the boardprefs.php file is:

$result = mysql_fetch_array($query);

My question is from all the examples of using mysql_fetch_array() is that $result usually equals mysql_query, then $row = mysql_fetch_array() Is it possible to use the code like this?

$query = mysql_query("select * from alleg_prefs");
$result = mysql_fetch_array($query);

or will the code have to be rewritten.

Any insight would be great, i've contacted the writer of the script but have not recieved a response.

Thank you.

Anon

try with mysql_db_query

Carrie wrote:

I got this script that i'm trying to run. It takes character information from a game and is supposed to make a heirarchy tree with everyone's stats.

The setup creates all the tables for me, but when i attempt to run the setup it gives me this error:

Warning: Supplied argument is not a valid MySQL result resource in /www/chroniclesoftao.org/html/tree/boardprefs.php on line 4

the line it's talking about from the boardprefs.php file is:

$result = mysql_fetch_array($query);

My question is from all the examples of using mysql_fetch_array() is that $result usually equals mysql_query, then $row = mysql_fetch_array() Is it possible to use the code like this?

$query = mysql_query("select * from alleg_prefs");
$result = mysql_fetch_array($query);

or will the code have to be rewritten.

Any insight would be great, i've contacted the writer of the script but have not recieved a response.

Thank you.

we_win

U r right
u can use it that way.
Infact if u want a single statement
u can rewrite the same as

$result = mysql_fetch_array(mysql_query("select * from alleg_prefs"));

Anon

ok, i will try those when i get home.

What would cause that error if the code is ok?