[Resolved] mysql count entries

goaman

hi guys,
I need help on counting the entries from mysql db. Table name is "uploads", I want to know how to count all the entries and view it as total uploads.

I've tried it didn't work:

//Connect to db
include 'dbconfig.php';
//select and count
$query = mysql_query("SELECT id, Count(id) FROM uploads ");
$row = mysql_fetch_array($query);
$id = $row['id'];
//total entries
echo 'Total uploads: $id';

pls lend me a hand on this one.. thanks in advacne.

onion2k

//Connect to db
include 'dbconfig.php';
//select and count
$query = mysql_query("SELECT Count(id) as total FROM uploads group by id");
$row = mysql_fetch_array($query);
$total = $row['total'];
//total entries
echo 'Total uploads: $total';

goaman

Originally posted by onion2k

//Connect to db
include 'dbconfig.php';
//select and count
$query = mysql_query("SELECT Count(id) as total FROM uploads group by id");
$row = mysql_fetch_array($query);
$total = $row['total'];
//total entries
echo 'Total uploads: $total';

[/B]

Hi!
I don't have 'total' named row in my table so that I can grab it from db. There for this code's result will return as nil. Is there any way to count amount of pictures from a table?

table name is 'uploads'.
rows: id | pictures | uploaded_user

onion2k

Originally posted by goaman
There for this code's result will return as nil.

Did you try it?

goaman

Originally posted by onion2k
Did you try it?

yes, it shows:

Total uploads: $total

onion2k

Originally posted by goaman
yes, it shows:

Total uploads: $total

Thats because you're using single quotes. I figured you'd done that on purpose in your code for some reason, hence I didn't fix it when I copied your original. Use:

echo "Total uploads: $total";

goaman

Originally posted by onion2k
Use:

echo "Total uploads: $total";

This way it won't count the numbers of entries, I was trying to echo the number of the entries like this:

echo "Total uploads: $id";

I know this way is wrong since it doesn't show the numbers of the entries. Thats the reason I ask if anyone know how to get the numbers of entries.. I'm sorry if my question isn't very clear. I wonder if you understood my question right. 😕

let me try to clear my question:

I've got a table called: uploads, and I've got 3 fields inside the table called:
id, picture_name and username.

There are many uploaded picture entries, now what I'm asking is how to get the numbers of the uploaded files.

onion2k

Your original post says "I want to know how to count all the entries and view it as total uploads". Which is what I answered.

Lets start over. Without posting any code, what exactly do you want your script to do?

goaman

Originally posted by onion2k
Your original post says "I want to know how to count all the entries and view it as total uploads". Which is what I answered.

Lets start over. Without posting any code, what exactly do you want your script to do?

As I said on my previous post, I want the script to see how many files are uploaded by counting the entries from db.

I've got a table called: uploads, and I've got 3 fields inside the table, they are named as: id, picture_name and username.

There are many uploaded picture names are stored, now what I'm asking is how to get the numbers of the uploaded files to show the uploaded pictures in total.

I think it's more clear now.. 🙂

onion2k

$query = mysql_query("SELECT COUNT(id) AS total FROM uploads GROUP BY id");
$row = mysql_fetch_array($query);
$total = $row['total'];

$total will definately be the total number of rows stored in the uploads table. If thats not what you're after then I've completely misunderstood again, and I'll have to leave it for someone else to answer.

tsinka

onion2k ...

I think that's not completely true. The GROUP BY clause causes MySQL to group the results by id. if id is an auto_increment then you'll get n records where n is the number of rows in the table and a total of 1 for each row.

SELECT COUNT(*) AS total FROM uploads

without the GROUP BY should return the total number of rows in the table.

Thomas

goaman

Originally posted by onion2k
$query = mysql_query("SELECT COUNT(id) AS total FROM uploads GROUP BY id");
$row = mysql_fetch_array($query);
$total = $row['total'];
$total will definately be the total number of rows stored in the uploads table. If thats not what you're after then I've completely misunderstood again, and I'll have to leave it for someone else to answer. [/B]

Yes, you are right.. It's gave me 1 as result, it shows the right amount since I've removed the Group BY id as you have suggested, thankyou guys, thankyou v much Thomas, I appreciate your help guys. thanks again.