CAN ANYONE HELP ME PLEASE?????????????????????outlaw wrote:Hi there i got it to display only 1 line per user but i dont know how to
add up the numbers.
this is my query i use, should i change it?
Code: Select all
$query=" SELECT * from $tbl1 where $fld1 between '$dfrom' and '$dto' group by $fld2";
Search found 9 matches
- Tue May 24, 2005 5:57 am
- Forum: Databases
- Topic: Duplicate Data
- Replies: 6
- Views: 1379
- Sat May 21, 2005 10:49 am
- Forum: Databases
- Topic: Duplicate Data
- Replies: 6
- Views: 1379
Hi there i got it to display only 1 line per user but i dont know how to
add up the numbers.
this is my query i use, should i change it?
add up the numbers.
this is my query i use, should i change it?
Code: Select all
$query=" SELECT * from $tbl1 where $fld1
between '$dfrom' and '$dto' group by $fld2";- Sat May 21, 2005 2:27 am
- Forum: Databases
- Topic: Duplicate Data
- Replies: 6
- Views: 1379
- Fri May 20, 2005 1:23 pm
- Forum: Linux
- Topic: Linux Distros - Distro War
- Replies: 14
- Views: 11782
- Fri May 20, 2005 1:17 pm
- Forum: Databases
- Topic: Duplicate Data
- Replies: 6
- Views: 1379
it's obvious it's not a very sane design to have only one column where you might have wanted at least 2. (one for the text, one for the number). that way you could have easily done: SELECT text, SUM(number) FROM table GROUPBY text Now you will have to look at the string functions of your dbms to ex...
- Thu May 19, 2005 3:07 pm
- Forum: Linux
- Topic: Server Distro
- Replies: 19
- Views: 23470
- Thu May 19, 2005 3:01 pm
- Forum: Linux
- Topic: Desktop Distro
- Replies: 39
- Views: 44334
- Thu May 19, 2005 2:51 pm
- Forum: Linux
- Topic: Linux Distros - Distro War
- Replies: 14
- Views: 11782
- Thu May 19, 2005 2:31 pm
- Forum: Databases
- Topic: Duplicate Data
- Replies: 6
- Views: 1379
Duplicate Data
can anyone tell me how i can get data from mysql eg outlaw linux php 10 outlaw linux php 11 linexus linux php 12 linexus linux php 13 linexus linux php 14 how can i show only one line but add up the numbers at the end of the line to get a total for each user so the output would be outlaw linux php 2...