added variables to a database array

Rayn

ok lets say I have a database variable

$stuff = mysql_query("SELECT * FROM table WHERE this = that");

now once I have that I want to manually add variabes to the db array like

$stuff[new] = "addon";

but everytime I try the variable is not there, so my question is... is there a way to do what I am asking?

laserlight

[man]mysql_query/man returns a result resource, not an array.

You have to use [man]mysql_fetch_array/man or [man]mysql_fetch_assoc/man to access it the way you want.

Incidentally, you should use $stuff['new'], not $stuff[new]

Rayn

i did use mysql_fetch_array() is just making things short.

Also I tryed what you suggested and still nothing. :\

laserlight

I've never tried messing with arrays returned from such functions, so I dont really know.

Could you give the exact code snippet?

cgraz

Don't use $stuff, that's the variable for your query...not the array that holds the records. Try something like this

$stuff = mysql_query("SELECT * FROM table WHERE this = 'that'") or die(mysql_error()); 
$row = mysql_fetch_array($stuff);

$row["manual_variable"] = "bla";

Cgraz