Suzanne — Sat, 06 Mar 2004 17:19:05 +0000

Oh, geez, you know, I just looked at it and realized it's not your PHP. It's your HTML! You have the table tag opening twice and closing once.

Suzanne — Sat, 06 Mar 2004 17:13:05 +0000

Okay, move it under the next variable and continue on doing this:

i.e.

if (!$result) { echo "nothing for \$result!"; exit; } else { echo $result; exit; }
if (!$row) { echo "nothing for \$row!"; exit; } else { echo $row; exit; }
if (!$subtotal) { echo "nothing for \$subtotal!"; exit; } else { echo $subtotal; exit; }

It's hard to troubleshoot when there is nothing returned at all.

Edit: we're posting at the same time -- use above for each of the $GST variables, and try the HEREDOC syntax.

redhead — Sat, 06 Mar 2004 17:10:59 +0000

If i change the code to just this:

<?php
 
    include (\"dbconnect.php\"); 
    $sql = \"SELECT SUM(price) FROM ordertemp\";; 
     if (!$sql) { echo mysql_error(); exit; }
    $result = mysql_query($sql, $db); 
    $row = mysql_fetch_row($result); 
    $subtotal = $row[0];    
   echo\" 
        <table  border=1> 
              <tr> 
            <td>Subtotal</td> 
            <td>$subtotal</td> 
            </tr> 
            </table> 
  \"; 
 
?>

This works

i'm just not sure why i was unable to add taxes and stuff

redhead — Sat, 06 Mar 2004 17:07:33 +0000

I added in the if line right after my sql line and still got nothing.. Uisng phpMyAdmin i tested the sql line and was able to get a total..

But if i run the page i get nothing any more ideas!

Suzanne — Sat, 06 Mar 2004 16:51:59 +0000

After your $sql line:

if (!$sql) { echo mysql_error(); exit; }

Are you getting a result?

Then walk through and echo out your variables and exit so you know where it's breaking down.

Also, you should look into the HEREDOC syntax.