array 1

[iranor]

I have a mysql query that select numbers from a table.

With these numbers , I do an array.

How can I multiply these numbers and add the result in a variable?

 

[sleipnir214]

You've fetched numbers from MySQL and stored them in an array.

What is it you wish to do with the numbers in the array?


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[iranor]

I want to select all numbers from a certain field , make an array , then multiply all the numbers and return the result.

I've done the array , now I just need to know how to multiply and return result from the array

 

[tweenerz]

Since you are looping through the result set, simply multiply as you go. Am I missing something? If you loop through the result set and store it in an array, you will have to loop through the array again - seem likes unneccessary replication to me.

Let me know if I am missing something.

 

[sleipnir214]

I would set some variable to 1, then loop through the array, multiplying the variable by every element in the array.


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[iranor]

let say I do :

$total_used = array('10','10','10');

How can I multiply the above numbers so the result here would give 1000 ?

 

[sleipnir214]

Again.

Set a variable to 1. Loop through the array and multiply the variable by each element of the array.


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[iranor]

still don't understand... could you give me an example please

 

[sleipnir214]

What part do you not understand?

I'm very confused. This is a very basic array-manipulation question.


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[iranor]

$total_used = array('10','10','10');

Let say it's my array. How would you multiply these and return the result?

I'm not very good in using arrays

 

[sleipnir214]

Again, what part of my answer do you not understand how to do?

Assigning a value to a variable?
Looping through the elements of an array?
Performing multiplication?


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[iranor]

Thanks , I found.

<?
$total_used = array('10','10','10');
$result = 1;
foreach($total_used as $number){
$result = $number * $result;
}
echo "$result";
?>

 

[sleipnir214]

That's exactly what I described.



I notice you used the verb "found", not "developed" or "wrote" or "created".

I strongly recommend that you take the time to get familiar with the basics of data-structures and manipulating them.


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[iranor]

Well , i know basics... I'm doing an online game for the phpbb forum now

 

[sleipnir214]

That may be. But I see in your question evidence of substantial gaps in your knowledge of data-structure manipulation.


Want the best answers? Ask the best questions!

TANSTAAFL!!