[RESOLVED] Array Data Help

jamesjohnson88

Hi, whilst i'm not really 'new' to PHP, I haven't used arrays all that much, not in this sense at least...

The array is in question is an assoc array, and i'd like to get the key name and it's value and put them in a table (HTML).

”Array ( [Username] => James [Password] => 8063b4d64886bcf42552200f95cacc58997e4dea5b66e87f517f9713b17fddba [Salt] => 0 [Money] => 622 [Bank] => 10000 [Lincoln] => 44 [Loughborough] => 0 [Lady_GaGa] => 0 [Xbox] => 0 [Playstation] => 0 [Wii] => 0 [Football] => 0 [Rugby] => 0 [Golf] => 0 [Paris] => [London] => [F1] => [New_York] => [Cricket] => )

The format for the table will be dependent on having a value greater than 0, furthermore, I would like to discard the first few keys (Username - Bank). So, then my table can be as follows.

E.g.

Lincoln | 44
Rugby | 102
etc. etc.

It will have more columns but i'm confident i'll be able to do that myself.

So, what do you think the best way to go about doing it would be? If you could relate your answers to the query below, that would be helpful as I think it will be easier to understand.

$usArray = mysql_query("SELECT * FROM Users WHERE Username = '$usr' LIMIT 1") or die(mysql_error());
$usRow = mysql_fetch_assoc($usArray);

dalecosp

Well, can you give a clue what the table output should look like?

As for processing, a general idea is something like:

do_some_database_stuff();

output_some_starting_HTML_like_table_and_opening_tr_tag();

while ($somevar=mysql_fetch_assoc($some_db_resource)) {

   do_some_HTML_with_PHP_mixed_in();

There are, perhaps, other valid approaches. Reading all the data into an array (thereby creating a multidimensional array) would be a possibility. The drawbacks: it's a bit more complex, and it could eat up a lot of RAM if your dataset is large.

jamesjohnson88

Yeah, i've used php populated tables before but I guess, really, what i'm asking, is how to select the values from the array.

I know the function to get the key, which will give me half the data I need but i'm not sure how to pull out the value.

So, for '[Bank] => 10000', I can get 'Bank' but I don't know how to get the '10000'. Would it be something like $usRow[Bank] in relation to the code in my original post?

jamesjohnson88

Actually, I see how to do it now. I think i'll need a new SQL table to do achieve what I need, so, i'll get on that...

Thanks your for your help though! =)

dalecosp

Well, I don't see why you'd need a table offhand, but I don't know much about your application or your DB design or content.

You do know about foreach() and arrays?

$girls=array("brunette" => "Mary Ann", "redhead" => "Ginger", "blonde" => "Miss March");
foreach ($girls as $key => $value) {
   echo "$value is a $key. <br />\n";
}

jamesjohnson88

The amounts of columns and the data in them changes often, so I need the separate table to store the names of the relevant columns so I can then use that as an array in my foreach loop.

Yeah, I know about the foreach() stuff, I was just thinking that I could perhaps accomplish everything I needed with the one array but I have since come to realise that that was a misestimation.