Array problem

[oomotayo]

using this query:

    $queryC = "SELECT * FROM  tbl_courses WHERE course_id='$course_id'";
        $resC = mysql_fetch_assoc(dbQuery($queryC));    
        $allUnits = $resC[course_unit];
print_r(array($allUnits));

returns:
Array ( [0] => 3 ) Array ( [0] => 3 ) Array ( [0] => 2 ) Array ( [0] => 2 )

but am expecting it to return

Array ( [0] => 3 ) Array ( [1] => 3 ) Array ( [2] => 2 ) Array ( [3] => 2 )

anybody whit usefull help please....

I need it as soon as possible

Thanks in advance

[pritaeas]

Try:

print_r($allUnits);

[oomotayo]

i tried it....i wanna sum the result return and use it in another calculation

Thanks for the reply

[pritaeas]

Can you explain what you are trying to do with an example?

[oomotayo]

i am trying to get the course credit unit for cgpa calculation

<?php
$EnrollKey = $_GET['m'];
    db_connect();

    //  $sqlStud = "SELECT * FROM tbl_stud_registration WHERE stud_id='$EnrollKey'";
        //  $resStud = dbFetchArray(dbQuery($sqlStud));
            //$get_stud_id = $resStud['stud_id'];

            //echo $EnrollKey.'==>'.$get_stud_id;

    $stm = "SELECT * FROM enrolled_courses WHERE stud_id = '$EnrollKey'";
    $stmQuery = dbQuery($stm);


?>

<form id="formID" name="form1" method="post" action="<?php $_SERVER['PHP_SELF']; ?>">

<span class="clearfix">&nbsp;</span>
    <fieldset>
    <div class="enroll">
    <table cellspacing="0" width="100%">
      <thead>
        <tr>
          <th width="7%">course</th>
          <th width="28%">course title</th>
          <th width="5%">unit</th>
          <th width="7%">status</th>
          <th width="6%">score</th>
          <th width="6%">grade</th>
          <th width="3%">w.g.p</th>
          <th width="38%">&nbsp;</th>
        </tr>
      </thead>

      <tbody>
        <tr>
 <?php
//for ($i = 0; $i < $num_result; $i++) {
         while( $row = dbFetchArray($stmQuery)) {
             extract($row);      

        $querySes = "SELECT * FROM  tbl_registration_session WHERE session_id='$session'";
            $resSes = dbFetchArray(dbQuery($querySes)); 

        $queryC = "SELECT * FROM  tbl_courses WHERE course_id='$course_id'";
            $resC = mysql_fetch_assoc(dbQuery($queryC));    
            $allUnits = $resC[course_unit]; 
        //  foreach($allUnits as $values) {
            //  echo $values; } 

        $qr = "SELECT SUM(course_unit) FROM tbl_courses WHERE course_id='$course_id'";  
            $qr_res = dbFetchArray(dbQuery($qr));
            //echo $qr_res['SUM(course_unit)']; 

    //  $query_reg = "SELECT * FROM tbl_stud_registration WHERE stud_id='$get_stud_id'";
    //      $resReg = dbFetchArray(dbQuery($query_reg));

?>  

          <td><?php echo $resC[course_code] ; ?></td>
          <td><?php echo $resC[course_title] ; ?></td>
          <td><?php echo  $allUnits; ?></td>
          <td><?php echo $resC[course_status]; ?></td>
          <td><?php echo $score; ?></td>
          <td><?php $gd = __gradingSystem($score); echo $gd."PTS"; ?></td>
          <td><?php $wgpa = array($allUnits*$gd); echo $allUnits*$gd; ?></td>
          <td><?php print_r($wgpa); print_r($allUnits);?></td>
        </tr>
        <?php print_r(array($allUnits));?>
<?php } ?>
      </tbody>
    </table>
    <div class="width50 float-left text-align-right">
      Total Credit Unit: <strong><?php $cr = __sumCreditUnit($arr); echo $cr; ?></strong><br /><br />

[oomotayo]

To what i can debugg...i see that the array pocket[0] is holding all the values, if so how do i sum up everything in the array pocket or split it if possible to do my calculation

You can use array_sum() to sum the contents of an array.
If the array is coming from an SQL query, depending on how you're using it, you could use SUM() along with a GROUP BY.

[oomotayo]

thanks diafol...but i have tried that too.....its just retruning the last value...but now i wanna use jquery to do it...

i have this code if you can help with..

$(document).ready(function(){
  $('input[name="units[]"]').each(function(){
      alert($(this).val());
  });

});

its ouptuting all the values but i wanna sum the value and put the summation in a textbox

[richieking]

you can sum the value from an array in a very simple style. eg;

<?php
$value;
// Array value contain 40 int;
$array_int[39];
// Now sum the stuff;

for($value=0;$value < count($array_int);$value++){

 // Sum the value from the array
 $value +=$array_int[$value];

}
echo "the Ssum is ";
echo $value;

?>

You don't need javascript. That's not good.

thanks diafol...but i have tried that too.....

It's difficult to know what you're trying to do unless you explain which field(s) in the DB you're trying to sum.

If it's a number of fields for one record then, MYSQL can do it:

'SELECT field1, field2, field1 + field2 AS mysum FROM table1 WHERE field6 = 2319'

If it's a sum of values from mutliple records for one field:

'SELECT SUM(field7) FROM table1 WHERE field6 = 2319'

[oomotayo]

i guess the MYSQL SELECT SUM cant work if you are selecting from another database using the result from another database e.g

    $stm = "SELECT * FROM enrolled_courses WHERE stud_id = '$EnrollKey'";
    $stmQuery = dbQuery($stm);

             while( $row = dbFetchArray($stmQuery)) {
         extract($row); 
         //here course_id is extracted

    and



$qr = "SELECT SUM(course_unit) FROM tbl_courses WHERE course_id='$course_id'";  
            $qr_res = dbFetchArray(dbQuery($qr));
            echo $qr_res['SUM(course_unit)']; 

but its still not working......i have tried it several times and othere codes before posting my problem here

but its still not working.....

When you say 'database', I'm assuming you mean 'table'. Either way it doesn't matter, all you need is a JOIN and a SUM.

$r = mysql_query("SELECT SUM(tc.course_unit) AS cunit FROM enrolled_courses AS ec INNER JOIN tbl_courses AS tc ON ec.course_id = tc.course_id WHERE ec.stud_id = '$EnrollKey' GROUP BY ec.stud_id");
//need a row num check here, anyway...
$d = mysql_fetch_assoc($r);
echo $d['cunit'];