[RESOLVED] Problems selecting from mysql...

pettsogn

Hi!

I want to group rows that has the same value in a specific column like:

row1: 3
row2: 2
row3: 3

what do i do now to select row 1 and 3? The query has to be dynamic because the numbers can be any from 1 to 1000....

Thanks in advance 🙂

devinemke

i don't quite undertand the question. you want all rows where a certain field equals 3? simply put that in your query's WHERE clause.

pettsogn

i want to select rows that has the same value in that field...

I dont really know how to explain this very well... :S

devinemke

pettsogn wrote:
I dont really know how to explain this very well

you are right. i still don't undertand what you want to do.

pettsogn

maybe if i tell u the purpose.. 😛

im creating a game based on php and mysql...

I have a table wich stores all the attacks/defends.. when a player attacks someone, the attacked players id will be stored in that column, now i want to calculate the losses..

So what im trying to do know is first to select alle the players(rows) that attacks that player, and then select all the defenders(rows in the same table)...

Understand..?
(god damn, WHY did I quit in my english class..? :p)

edit: i've found a way around it 🙂