hi- i m having a problem finding a Query that will do what I need to do. to simplify this question I ll go through it with this example:

id------num
1---------9
2---------10
3---------10
4---------12
5---------12

i want an output to be like : 9-10-12.
the only thing that came close to what i have searched is: "SELECT DISTINCT num FROM `random`"- but this only gives me 1 number.

can someone help me out here?
thx

locally and when ready simply upload to my server and it will be accessible and live- is there such an all in one solution?

Hey - Im currently creating a user registration and login page with mysql and php using dreamweaver. My Mysql database is hosted online and uses Phpmyadmin. My infomation is correct but its not working. Everytime i click Register it says No database selected. Can someone explain whats wrong. Also how should i connect just so i know im doing it correct. Anything would be great. Thanks!
mysql_select_db("login"); - this is what i have to select the database already - login is the table name- is that something to do with it.
Should i connect to database or table. Basically i login using Phpmyadmin - then i select my database then table. My Table is called login.

<?
mysql_connect("db.fdb1.runhosting.com"- "128435_fs"- "-SECRET-");
mysql_select_db("login");
?>

that is my currecnt connecting code. The First bit is the host address - the next bit is phpmyadmin login - the password then login is the name of my table which i am trying to access.

Anyideas Please
OH HANG ON...

Just Messed with the Database and connected to the db not table. It now seems not to be returning an error but not actually adding the registration infomation to database. Also Login doesnt recoqnise it. Anyideas on this one?

Im working on a programming project which is by C# lang and mysql database.
What I want is when I enter a code number for example student s code in a textbox- after pressing "Enter" key- the rest of the form get filled automatically. (the rest of teh data like name or grades are all in the database).
I can insert data from c# to mysql but I cant retrieve data from mysql to C# environment...
P-S
I have done this by mysql_fetch_array with PHP lang

I use CentOS linux. Which MySQL RPM should I get? I don t see one listed for CentOS. (not using XAMPP)

I know how to use Joomla! but I`m not sure what MySQL and PHP have to do with Joomla! When I used it- someone helped me install it and helped me convert my html into Joomla! Do I need to know PHP to do that?