[RESOLVED] PHP Arrays

MitchEvans

Hi,

I have a table that I'm getting data from and I need to build an array of the details.

$audit = "SELECT * FROM audit WHERE username LIKE 'mitch'";
$auditResults = mysql_query($audit);
while ($auditRow = mysql_fetch_array ($auditResults)){
$total = $auditRow["total"];
}

How do I get an array of all the $totals that have a username of Mitch.

I've tried

$thearray = array($total);

I know its simple I have just totally forgot.

Thanks.

Drakla

Whatever your database field is called, let's say it's 'total'.

SELECT SUM(total) FROM table WHERE username = 'mitch';

MitchEvans

Hi I'm aware of the method you are stating but unfortunately my problems not that simple.

I have fields like so:

id,room,username, int1,int2,int3,int4,int5
36,dining,mitch,1,2,1,2,1
42,bed,mitch,1,2,2,2,1

I then work out that dining is worth 7 and bed is 8. I then want these details in an array.

Any ideas please?!

I need an array of these values:

$audit = "SELECT * FROM audit WHERE username LIKE 'mitch'";
$auditResults = mysql_query($audit);
while ($auditRow = mysql_fetch_array ($auditResults)){
$int1 = $auditRow["int1"];
$int2 = $auditRow["int2"];
$int3 = $auditRow["int3"];
$int4 = $auditRow["int4"];
$int5 = $auditRow["int5"];

$totals = $int1+$int2+$int3+$int4+$int5;

$totalarray = array($totals);
}

Unfortunately this doesn't work and build up an array of what I want. It only saves the last total not all the totals.

BillKat

Each run through the loop redefines the first element of $totalarray with whatever $totals is, it doesn' t add a new element to the array.
So $totalarray has one element, and when you refer to $totalarray[0] after running the while(), it holds the last value of $totals.

Below, a new element is added to $totalarray to a total for each record:

while ($auditRow = mysql_fetch_array ($auditResults)){
$totalarray[] = $auditRow["int1"] + $auditRow["int2"] + $auditRow["int3"] + $auditRow["int4"] + $auditRow["int5"];
}

Think that's what yr after.

MitchEvans

Ahhhh that's it I just needed the [] square brackets.

Thanks a lot!