I have a list of cities in a mysql table and I need to get them into a string separated by a minus ("-"). I used to have the cities in a simple text file, and used the following code to extract them into a string. $arr = file("data/cities.dat"); sort($arr); foreach($arr as $k=>$v){ $arr[$k]=trim($v); } $cities = implode('-', $arr); The result would be: $cities = "Chicago-New York-Cleveland-Seattle- Memphis"; Any idea how I can get them out of the table, and into a string like above? Thanks

The page linked below talks about the mysql_fetch_array function. After you run a query to get the data, you'd use mysql_fetch_array to get each row from the returned data. There are some small examples on the page. Post back if you need help figuring out the SQL or the database stuff. http://us.php.net/mysql_fetch_array

Well, it would be helpful to know the structure of your table. BUt, assuming the name of the table is "locations" and the field is "city", this should work: $query = "SELECT city FROM locations GROUP BY city"; $result = mysql_query($query) or die (mysql_error()); while ($record = mysql_fetch_assoc($result)) { $arr[] = $record['city']; } $cities = implode('-',$cityAry); Michael J

Thanks a lot guys. Your example worked perfectly, Michael. I knew how to get the data into a MYSQL array, but getting it into a string from there is what I didn't have a clue on. I'm very new to both PHP and SQL. Thanks again.