array_push into multidimensional array

davidjames52

Hi all,

I have developed some code to try and push a generated array into an existing array that is pulled from a database then reinsert it. But I dont think my array is being populated. If some one could have a look and tell me where I am going wrong it would be greatly appreciated.
Here is my code.

$recievearray = mysql_query("SELECT players FROM users WHERE players='$tnumber");
$recievearrayresults = mysql_fetch_array($recievearray);
$playerarray = unserialize($recievearrayresults['players']);
$playerarraycount = count($playerarray);
array_push($playerarray,array(Player1 => $userid, RegNumber => $playerarraycount+1, Rating => $rec['Rating']));
$newplayerarray = serialize($playerarray);

Then I reinsert it back into the database with a query.

Is this possible to push an array into another array to make it multidimensional.
Basically I want the final array to look like this.
array(array(blah blah blah),array(blah blah blah))

sneakyimp

i am not sure at all what you are trying to do, but it doesn't sound like you understand how to use a database.

this line of code will return an integer id which refers to a data resource...that number makes sense to other mysql functions:

$recievearray = mysql_query("SELECT players FROM users WHERE players='$tnumber");

from what i can tell, your database is defined such that the field called 'players' contains integers. by selecting that field from your table called 'users', you should probably be expecting your results to be full of integers.

this line of code fetches one record from that data resource. this record will be defined as an array.

$recievearrayresults = mysql_fetch_array($recievearray);

so basically $recievearrayresults is an array and $recievearrayresults['players'] is going to contain whatever is in the field named 'players' in the table called 'users'.

given all that, the rest of your code doesn't really make much sense. to unserialize an integer will cause an error. to store fully serialized data in a field called 'players' and try to retrieve records by querying for whichever records match this fully serialized data is an extremely poor database design.

davidjames52

Hiya,
what is intended with this code is to save peoples details in an array when they join an event. then that array of peoples details can be pulled and people can see who is signed up for it. I can do a single array with all the people but to pull all those peoples details would load down the server spec when there might be 255 people in the event. when people sign in there details are already there in a mysql query so I am trying to create a multidimensional array with there details that can be used on another page.

Piranha

I suggest that you read up on "database normalization", it will allow you to design the database in a better way. As an example, what if there are more people that have signed up to an event than there is places. It is the second time that event is run, and you don't want people that was there the first time, how do you solve that problem with this structure?

davidjames52

In reply to the normalization issue. In my coding people can only sign up to the event when the event is not closed with an if statement. As per the amount of people there is also another if statement ti take care of that issue. I know that I can insert a single dimension arrary pull that and adjust it. I have done this but to add more functionality I need to add the user details to the array and save it as an array in a array. that way I can just access the user by $playerarray[0][player] etc. Is there a way to do that or is there just an issue with the code above.

Thanks heaps

sneakyimp

You should read about the normalization issue and try to understand databases better. Your statements about your code and what you would like to do are really vague so it's impossible to answer your question, but most of what you say suggests that you are going about it in the wrong way.