GROUP

intenz

Hey, I've got a mysql table and one field that has the name "type", different records can have different type (e.g. PHP, ASP, .NET) ... how do I make one query which makes just one group with all the PHP records, one group with all the ASP records and one group with all the .NET records?

It should display like this:
http://brutal.@!#$.is/rusl/bullimer.htm

intenz

ROFL!!!
Try this:
http://212.30.210.115/rusl/bullimer.htm

I don't want to be forced to do it like this:
http://212.30.210.115/rusl/bullimer.phps

Anon

SELECT field FROM table GROUP BY field (ASC,DESC).

For example, imagine you have 9 categories.
Assuming category field is a text one,

SELECT COUNT(*) FROM table GROUP BY type DESC

This will group together all of the records on the same table sharing that same field with same value. Then it will return as many records as categories you have, having the result of the count of records sharing that field with that value. This is very useful i you want to tell how many of each kind there are.

Hope this helps

fLIPIS

intenz

Could you give me a larger example because I'm not familiar with this GROUP BY 😉

intenz

What is different about GROUP BY and ORDER BY type ?
I have no idea how to output a group.

flipis

Ok, i'll put a sample for you.

Imagine this set of records:

ID NAME NUMBER
1 fLIPIS 2
2 gaui 2
3 mYSELF 3
4 yOURSELF 3
5 uNREAL2 4
6 UT 4

Ok, put these records into a table. Then execute these queries:

SELECT FROM TABLE ORDER BY ID ASC;
SELECT FROM TABLE ORDER BY ID DESC;

SELECT FROM TABLE GROUP BY DESC ASC;
SELECT FROM TABLE GROUP BY NUMBER DESC;

SELECT COUNT() FROM TABLE GROUP BY NUMBER ASC;
SELECT COUNT() FROM TABLE GROUP BY NUMBER DESC;

By seeing the results you'll get to know what are these for.

fLIPIS

Anon

I thought that domain names like yours weren't allowed!

When I come to my favourite forum I don't expect to see sicko's strutting their stuff. I would have thought phpbuilder was a safe place to visit.

intenz

I still don't get it how to make it look like this:
http://212.30.210.115/rusl/bullimer.htm
..with just one query.

intenz

Ehhh...
Though the domain has fawk in it, it isn't necessarily a porno site.
I don't own this domain but I'm amazed too that this domain was accepted.