Cypher_489

NVM, I've fixed it now. [code]while ( $dirs = mysql_fetch_array($sql) ) {   $name = $name."$dirs[name], ";   $names = rtrim($name, ','); }[/code] Didn't need the last element info.

Anyone?

Just one more thing on this topic, I've found the last element in the array: $last_sql = mysql_query("SELECT * FROM dt_directories WHERE category = '$category' ORDER BY name DESC LIMIT 1") or die(mysql_error()); while ( $last = mysql_fetch_object($last_sql) ) { $last_element = "$last->name"; } How will I incorporate this into the $name variable so that the last element doesn't have the comma after it. I've tried a simple if( $name != $last_element) { $name = $name."$dirs[name], "; else { $name = $name."$dirs[name]"; } but that doesn't work, any ideas?

Brilliant, thats exactly what I wanted. Thanks for the quick replies.

I've tried echoing the $name variable outside while() { } before and I only got the last directory in the array.

Hi, Just a simple question. [code] $sql = mysql_query("SELECT * FROM dt_directories WHERE category = '$category'") or die(mysql_error());   while ( $dirs = mysql_fetch_array($sql) ) { $name = $dirs['name']; echo "$name, "; }[/code] This echos out the names of directories which are from the category stored in the variable $category like this (category is "general"): Dmoz, Yahoo, Best of the Web, and so on... What I want to do is, rather then echo it, is to store them in a variable with the formatting like in the example. TIA