Search found 9 matches

by outlaw
Tue May 24, 2005 5:57 am
Forum: Databases
Topic: Duplicate Data
Replies: 6
Views: 1379

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";
CAN ANYONE HELP ME PLEASE????????????????????? :?:
by outlaw
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?

Code: Select all

$query=" SELECT * from $tbl1 where $fld1 
between '$dfrom' and '$dto' group by $fld2";
by outlaw
Sat May 21, 2005 2:27 am
Forum: Databases
Topic: Duplicate Data
Replies: 6
Views: 1379

Thanks will try and let you know...thanks again.
by outlaw
Fri May 20, 2005 1:23 pm
Forum: Linux
Topic: Linux Distros - Distro War
Replies: 14
Views: 11781

I must say i like how easy it sometimes is to install apps in windows
although when they do fail the amount of detail given why is muchless
than what linux gives.Oh and i like the look of XP...wonder whats in store
for LongHorn
by outlaw
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...
by outlaw
Thu May 19, 2005 3:07 pm
Forum: Linux
Topic: Server Distro
Replies: 19
Views: 23467

Pyrite wrote:So does Microsoft Windows, does that make it good?
HAHAHAHAHAHAHAHAHAHAHAHAHAHAHAHAH :lol:
by outlaw
Thu May 19, 2005 3:01 pm
Forum: Linux
Topic: Desktop Distro
Replies: 39
Views: 44332

i chose Fedora because i like it and i think its very user friendly for
anyone new and good enough for experienced users.Although any linux distro
is a good choice.

for entertainment i think mandrivia is best.
by outlaw
Thu May 19, 2005 2:51 pm
Forum: Linux
Topic: Linux Distros - Distro War
Replies: 14
Views: 11781

Pyrite wrote:On contraire, I think 99% of the ppl in this forum are Windows user's.
Hi i am one of the 1% that uses linux...i cant use windows its to difficult
for me...i have and all linux three distro boot machine.i would like to learn to use windows though
by outlaw
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...