Iam having a $bonus math problem

Iank

this code is supose to add everything together and display it on a feed but it doesnt add past the 25 bonus.

heres the code

function GetLoginStories ($user) {
  global $bonus_table;

  if (!is_numeric ($user))
    return;

  $bonus = array ();
  $bonus["bonus"] = array ();
  $result = Query ("SELECT unix_timestamp(date) as date,reg_add,lj_bonus,ic_bonus,hu_bonus,rod_bonus,chr_bonus,val_bonus,bug_bonus,camp_bonus,ch_bonus,coin_bonus,bill_bonus,bd_bonus,bb_bonus,cookie_bonus,metal_bonus,gem_bonus FROM $bonus_table WHERE uid=$user");

  $num = mysql_num_rows ($result);

  for ($i=0; $i<$num; $i++) {
    $bonus_amt = 25 + mysql_result ($result, $i, "reg_add") + mysql_result ($result, $i, "bb_bonus") * 4 + mysql_result ($result, $i, "cookie_bonus") * 4 + mysql_result ($result, $i, "camp_bonus") * 4 + mysql_result ($result, $i, "bug_bonus") * 4 + mysql_result ($result, $i, "lj_bonus") * 8 + mysql_result ($result, $i, "ic_bonus") * 8 + mysql_result ($result, $i, "hu_bonus") * 8 + mysql_result ($result, $i, "ch_bonus") * 12 + mysql_result ($result, $i, "bd_bonus") * 12 + mysql_result ($result, $i, "rod_bonus") * 12 + mysql_result ($result, $i, "coin_bonus") * 16 + mysql_result ($result, $i, "bill_bonus") * 16 + mysql_result ($result, $i, "chr_bonus") * 50 + mysql_result ($result, $i, "val_bonus") * 25 + mysql_result ($result, $i, "gem_bonus") * 20 + mysql_result ($result, $i, "metal_bonus") * 20;
    //$bonus_amt=5;
    $bonus["bonus"][$i] = array (mysql_result ($result, $i, "date"), "<fb:name uid=\"$user\" /> received $bonus_amt Extremebucks on logon!");
  }

can anyone help me as to why its not adding past the $bonus_amt = 25 + mysql_result ($result, $i, "reg_add")

its also not displaying on the main page

thanks

shawty

Looks like you have a mixture of data types in the result.

Top and bottom of it is, if you have even just one string in there, the whole thing will fail.

is for numbers and . is for strings

also , i'm not sure exactly how your using mysql_result here, but to get the actual row data you need to use "mysql_fetch_row" or "mysql_fetch_assoc". This will get the actual values into an array which will be numerical if fetch_row is used and named as per the table columns if fetch_assoc is used.

How i would approach the solution would be as follows...

$total = 0;
$query = "SELECT value FROM table";
$result = mysql_query($query);
while($line = mysql_fetch_row($result))
{
$value = $line[0];
$total = $total + $value;
}

Substitute 'value' for which ever columns you need to sum up, and if your using fetch_row, then the order of the results will be left to right starting at 0.

Cheers

Shawty

Iank

that will let it display on the main page as well?

Iank

I sooo need help with this to get it to add and display on the main page lol

shawty

No it won't display it, all my snip-it of code does is sum up the total into the $total variable.

You can then use "print "<h1>".$total."</h1>"; or what ever you need to display the value.

When your displaying HTML code you need to use the print and/or echo statments to generate your page. Normally if your using some kind of framework, then this will produce the output for you, however you'll need to read the docs to find out how it needs it's data sending to it.

As an example, if i was writing a plug-in for typo3 then i would not use print or echo, i would set a variable called $output with my page content and typo3 would display it.

If you are producing your own output however you will need to use print & echo to produce the page otherwise you'll not see anything at all.

I'm currently writing a series of beginners articles for PHPBuilder called 'The ABC of PHP' and they should be getting published in the articles section in the near future, this will help you with your ouput problem.

As for summing up the data above, the example i gave you is only ment to illustrate how to do it, and not actually a final solution.

The $value items and the $line[x] entries should be changed as appropriate depending on the mathematical formula you want to achieve.

going back to my previous example you might change it to


  $total = 0;

  $query = "SELECT value1,value2 FROM table";
  $result = mysql_query($query);
  while($line = mysql_fetch_row($result))
  {
    $value1 = $line[0];
    $value2 = $line[1];

$total = $total + ($value1 * $value2);
  }

Examine the previous code, and this bit of code, note where the differences are, then use that as a template to re-write your original code so that it performs it's own calculation correctly.

Iank

ok thanks so much. I will work on it and let you know how it goes

shawty

Any time Ian, best of luck.

Best way to learn is always to play with code, rather than copy it :-)

Cheers

Shawty