PHP - Need Help With Multiplication App

Hi,

I have the following script:


<?PHP

$match = '/.*?\\d+.*?(\\d+)(\\s+)/is' ;

$dbh = new PDO('mysql:host=localhost;dbname=xxxx', 'xxxx', 'xxxx') ;

$result = $dbh->query("SELECT companyName, invoiceAddress FROM detail_sheets WHERE area = 'Germany'") ;
$codes = array() ;
$names = array() ;
$c0s = array() ;
$c1s = array() ;
$c2s = array() ;
$c3s = array() ;
$c4s = array() ;
$c5s = array() ;
$c6s = array() ;
$c7s = array() ;
$c8s = array() ;
$c9s = array() ;
while($row = $result->fetch(PDO::FETCH_ASSOC)) {

if(preg_match($match, $row['invoiceAddress'], $matches)) {

$codes[] = substr($matches[1], 0, 1) ;
$names[] = $row['companyName'] ;
//array_push($found, substr($matches[1], 0, 1), $row['companyName']) ;

}

}

$i = 0 ;
foreach($codes as $current) {

$currentName = $names[$i] ;

$result = $dbh->prepare("SELECT (sum(partbaskets.total) - sum(pourbaskets.total)) AS Margin
   FROM partbaskets, pourbaskets, enquiries, jobs
   WHERE partbaskets.enquiryRef = enquiries.id
   AND pourbaskets.enquiryRef = enquiries.id
   AND jobs.enquiryRef = enquiries.id
   AND jobs.status != 'Cancelled'
   AND enquiries.enqState != 'Inert'
   AND enquiries.companyName = ?
   ") ;
$result->bindParam(1, $currentName, PDO::PARAM_STR) ;
$result->execute() ;

while($row = $result->fetch(PDO::FETCH_ASSOC)) {

if($current == 0 && $row['Margin'])
array_push($c0s, $row['Margin']) ;
if($current == 1 && $row['Margin'])
array_push($c1s, $row['Margin']) ;
if($current == 2 && $row['Margin'])
array_push($c2s, $row['Margin']) ;
if($current == 3 && $row['Margin'])
array_push($c3s, $row['Margin']) ;
if($current == 4 && $row['Margin'])
array_push($c4s, $row['Margin']) ;
if($current == 5 && $row['Margin'])
array_push($c5s, $row['Margin']) ;
if($current == 6 && $row['Margin'])
array_push($c6s, $row['Margin']) ;
if($current == 7 && $row['Margin'])
array_push($c7s, $row['Margin']) ;
if($current == 8 && $row['Margin'])
array_push($c8s, $row['Margin']) ;
if($current == 9 && $row['Margin'])
array_push($c9s, $row['Margin']) ;
}
$result = NULL ;
$i++ ;
}

echo "<table><tr><td>Area</td><td>Margin</td></tr>" ;
echo "<tr><td>Area 0</td><td>" . array_sum($c0s) . "</td></tr>" ;
echo "<tr><td>Area 1</td><td>" . array_sum($c1s) . "</td></tr>" ;
echo "<tr><td>Area 2</td><td>" . array_sum($c2s) . "</td></tr>" ;
echo "<tr><td>Area 3</td><td>" . array_sum($c3s) . "</td></tr>" ;
echo "<tr><td>Area 4</td><td>" . array_sum($c4s) . "</td></tr>" ;
echo "<tr><td>Area 5</td><td>" . array_sum($c5s) . "</td></tr>" ;
echo "<tr><td>Area 6</td><td>" . array_sum($c6s) . "</td></tr>" ;
echo "<tr><td>Area 7</td><td>" . array_sum($c7s) . "</td></tr>" ;
echo "<tr><td>Area 8</td><td>" . array_sum($c8s) . "</td></tr>" ;
echo "<tr><td>Area 9</td><td>" . array_sum($c9s) . "</td></tr></table>" ;
?>


But what is happening is that the Margin is being multiplied by the number of rows in partbaskets (which is the same amount of rows in pourbaskets).

So for instance, if there is one part per job for a companyName, there is no problem and I get the correct margin.

But, if there is say 4 parts for one of the jobs, then the margin for that job will be multiplied by 4, which is wrong.

I have tried using GROUP but it didn't help.

Can someone please give me the missing link in my SQL statement?

hi i need to get value after Multiplication in a loop as total, please how can i do that here is my  code


while ($row = mysql_fetch_array($name)) {?>
<td><?php echo  $row['service']; ?></td>
<td><?php echo $result['qty'] ; ?></td>
<td><?php echo $total = ($result['qty'] * $row['price']); ?></td>
<?php  } ?>

i need to get $total of sum after loop, currently it shows only individual.. thanks for any help..
Regards

Code: [Select]
<?php      

echo "<tableborder=1>";
echo "<table> \n";                    
echo "    <tr>\n"; 

$a= 1;
$b= 1;

while ($a <= 9 && $b <= 10){
$calc = $a * $b;


echo "        <td>$calc</td>\n";

        $a++;

if ($a == 9){

echo "   </tr>\n";

    if ($b < 10)

echo "   </tr>\n";

 $a = 1;

 $b++;
}
}


echo "</table>";
?>

I am trying to do the multiplication tables but so far i can only manage to get this.
it only shows the answers but i want it to show the tables along with the calculation, so for example:
1*2=2
2*2=4 etc.
I want it to show on a repeating loop so it runs up to the 9 times tables.
Any help on this?

I am new to php and need help creating addition and multiplication tables using the html code we were given. I feel like I am on the right track, but I am getting a few errors and I cant figure them out. One of the errors is that it tells me I am not putting in a valid number for rows even though it is a positive number so it should work. Here is my code and all help is appreciated thanks in advance.  

<html>
    <head/>
    <body>
    <form method="POST" action="<?= $_SERVER['PHP_SELF'] ?>">
      <table border="1">
     <tr><td>Number of Rows:</td><td><input type="text" name="rows" /></td></tr>
     <tr><td>Number of Columns:</td><td><select name="columns">
    <option value="1">1</option>
    <option value="2">2</option>
    <option value="4">4</option>
    <option value="8">8</option>
    <option value="16">16</option>


      </select>
    </td></tr>
    <tr><td>Operation:</td><td><input type="radio" name="operation" value="multiplication"     checked="yes">Multiplication</input><br/>
    <input type="radio" name="operation" value="addition">Addition</input>
    </td></tr>
    </tr><td colspan="2" align="center"><input type="submit" name="submit" value="Generate" /></td>    </tr>
    </table>
    </form>


    <?php


        //check to see if num of rows is numberic
        if (isset($_POST["rows"]) && is_numeric($_POST["rows"])){
                //check to see if rows is a positive number
                if($_POST["rows"] > 0){


                if(isset($_POST) && $_POST['operation'] == "multiplication")
                {
                        for($r = 0; $r < $_POST["rows"]; $r++){
                                echo '<tr>';


                                for($c = 0; $c < $_POST["columns"]; $c++){
                                        echo '<td>' .$c*$r. '</td>';
                                echo '</tr>';


                                }}
                }


                else if (isset($_POST) && $_POST['operation'] == "addition")
                {
                        for($r = 0; $r < $_POST["rows"]; $r++){
                                echo '<tr>';


                                for($c = 0; $c < $_POST["columns"]; $c++){
                                        echo '<td>' .$c+$r. '</td>';
                                echo '</tr>';
                        }
                     }
                }


                }
                else{
                echo 'Invalid rows columns parameters';
                exit();
                }
        }
        else{
        echo 'Invalid rows columns parameters';
        exit();
        }


    ?>
    </body>
    </html>

Is it possible to put a multiplication problem in the mysql "default value" field?
In my script I need to take the unit amount * quantity, I know how to do this in php, but can I just put my equation in the "default value" field in MYSQL and make it equal to another field?... Like excell?

Thanks