Pulling out certain information?

maxf

Please go to my final post in this thread to see how I got it working

Hey all,

I got my other problem taken care of, now I'm trying to do something else.

I have a table set up with 13 different variables I guess (columns maybe?). Things such as name, date, profit, username, password etc etc. What I want to do is have my little HTML/PHP page run through the database and count up the total profit. How would I go about doing this? Profit is just called Profit. Thanks!

bubblenut

SELECT SUM(profit) FROM table

maxf

Thanks for the quick reply.

But, I can't seem to get it to work right. Here's what I've got:

$tprofit = SELECT SUM(profit) FROM $table;

It just gives me a parse error 🙁 n00b

bubblenut

No you have to use that as your database query. So, for example, if you're using a MySQL database you'd do the following.

<?php
//Connect to the db server and select the database
$res=mysql_query('SELECT SUM(profit) FROM table');
$row=mysql_fetch_array($res,MYSQL_NUM);
echo($row[0]);

HTH
Bubble

maxf

Thanks for putting up with me, but I'm still doing something wrong even though you've given the code to me 🙁

Here's what I've got:

$res = mysql_query('SELECT SUM(profit) FROM $table');
$totp = mysql_fetch_array($res,MYSQL_NUM);

And it returns this:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/supetraf/public_html/base.php on line 28

I also tried replacing array with field and got the same thing. Thanks again

maxf

Got it working!

Here is the code that works for me:

$res=mysql_query('SELECT SUM(profit) FROM clients') or die($sql.' : '.mysql_error());
$totp = mysql_fetch_array($res,MYSQL_NUM);

($totp is the total profit.) I didn't know that you can't use a variable inside of single quotes (for the table name which happens to be clients). It's also important to note that when you're using the variable ($totp in this case) that you add [0] to the end of it (so $totp[0]) because it's an array.

So thanks for all of your help BubbleNut! You're the master!