salam sejahtera..
saya bdak baru blajar php...
kalau tak keberatan leh tumpang tanya tak?
ape care/scripts/function yg paling senang tuk 'sum'kn jumlah rekod dlm db (mysql - dlm satu table.)?
thanks...
regards

thanks.. but
PHP:--------------------------------------------------------------------------------
$db = //db connection

$sql = mysql_query("SELECT * FROM table", $db);
$rows = mysql_num_rows($sql);

//echo $rows;

perhaps it works.....

mysql_num_rows kite bleh dapatkan jumlah rekod atau bil rekod yg affect ngan query?

apa beza ngan "select count(nama medan) from nama table";
thanks so much!!!

refards

There isn't much difference between that example and the one earlier if your not running a large database.

The performance factor between the two methods is negligible for a small database.

maybe my question does not so clear... what is really i want to ask is there any easiest way to 'sum' (count the sum) of your records in the db?
let say that
user vol
abu 5
abu 8
abu 9
ali 9

is a record on db.....
>> the sum of vol for abu is 22 right?
so... how can i get these '22'?

thanks.

Ic,

for this example we will have 2 fields:
Name (abu, ali, etc.) and
Number (5,9, etc.)

The easiest way is to do something like the following:

I haven't tested the code, but i'm quite sure it should work.

Use this SQL Why ... ?? Whenever possible, put the data calculation at the db server. Great advantage especially when webserver & db server are two different machine. Second, when dealing with text or string, use LIKE rather than "=".

__________________
--------------------------------------------
Khairil Iszuddin Ismail

btul tuh..
better buat kat sql query.. then buat count on looping...
jeb23 try ler sql query tuh...
mesti jadik nyer..
hahahahha...

__________________
^_^ <== stay happy

mr sufyan, kidino......
saya dah try dua2.. both code dapat result yg sama.....
thanks so much!!!!!!!!!!

ini pandangan aku ler... <== korang boleh celah kalau aku silap

result memang sama, tp lebih ekfisien (btul ke eja ni ) kalau guna terus kat query. sbb nak elak looping while tuh... so aku rasa lg cepat guna query tuh... cepat skit ler.. bukan byk pun.. hihihik

btul tak? ker salah?

__________________
^_^ <== stay happy

That is correct. Using the direct query method does eliminate a process and does improve efficiency. However, the improvement in performance between the two methods are negligible for a small database.

The example given in this topic is very basic. If you needed a more complex function, the second method would be of more use as you could intergrate the power of PHP to manipulate your data.

As for 'LIKE' rather than "=", I disagree with that statement as the equal sign (=) is the equivalent of IN in SQL, which returns exact matches.

LIKE is better used for a pattern with wildcards (%).

Anyhow, both methods will work ('IN' - = or 'LIKE' - without wildcards %), and there are no performance differences between the two.

ya ya! walaupun dah pakai zend optimize =)

__________________
I hate when:

vBulletin Message:
Sorry! The administrator has specified that users can only post one message every 60 seconds

aku tak ler hustler sgt..
so aku nak tanya ler..
zend optimize tu buat aper?
aper function dier dlm php?
aku dah baca skit review dier.
tp tak paham

__________________
^_^ <== stay happy

aler tambah performance bg yg run server lah.. tapi kalau small / developer x rasa beza pong...

__________________
I hate when:

vBulletin Message:
Sorry! The administrator has specified that users can only post one message every 60 seconds

Ooo..
benda tuh kena install kat server ker..
aku ingat dier cam ader panggil some other component..

ok tq

__________________
^_^ <== stay happy