As you have already said it yourself, you don't have to explicitly declare a variable as an array to use it like an array. You can simply use $var = "value"; This will treat $var as an array. But, its always a good practice to initialize a variable before using it. (But most of them don't do it ;) )
Allowing me to reuse the query again or in other words fetch it again?
Man nav php can be so annoying at times I fix one error and a new error pops up. I throw the arrays in a forloop and now more errors :( . Ill get back to debuging and keep you posted to see if anything works.
PS: can you run queries in a for loop? That could be a possible error? or declare it differently?
I don't know whats causing the error. You can run queries in a for loop. Once you have freed the result using mysql_free_result, that resource identifier is freed. Actually, if your query isn't too complicated, you don't have to use free_result as php frees the result at the end of execution of the script. Source: http://nl3.php.net/mysql_free_result