get the category

nagasea

Here is my question..
I got database like this :

Book
Book
Book
Book
Lamp
Book
Lamp
Lamp
Table
Table
Book

And I want to show that category like :
Book
lamp
Table

What mySQL / PHP command should I use.

dalecosp

Try "select unique foo from bar" where 'foo' is the name of the column (the one you posted) in the 'bar' table of your database.

And bookmark the Mysql.com site's manual section --- things like this are answered fairly easily there.

HTH,

seby

SELECT DISTINCT(YOUR_COLUMN_NAME) FROM YOUR_TABLE

dalecosp

$this=system(ping wall);

echo $this;

PING wall (wood.metal.glass): 128 data bytes
64 bytes from wall: icmp_seq=0 ttl=64 time=1057000.00 ms

--- wall ping statistics ---
1 packets transmitted, 1 packets received, 0% packet loss
round-trip min/avg/max/stddev = 1057000.00/1057000.00/1057000.00/0.000 ms