I think explode not sure

slimjim

If you can either show me how to do this or point me in right direction to understand so I can figure it out, that would be great.

I thought explode, but cant figure that out, so I am stuck cause I think there is an easy way...

In one colum in database and in one row I have lets say this :
one
two
three
four

Not :
one two three four

How can I get these to show just like that on seperate lines so that I can take each line and make the word a link..

Frederick

Sounds like you want to show the results as you enter them into a textarea field, I believe.

nl2br()

echo nl2br($row["fieldname"]);

slimjim

Well sorta like that but, if I have three of them like :

one
two
three

I need to be able to each in it's own link

When I just do it the below way, it is not working..


$query="SELECT word, cost from kwords ORDER BY cost DESC LIMIT 100";

$result = mysql_query($query) or die("Query failed");	


while ($myrow = mysql_fetch_array($result)) {


?>

<a href='list.php?kword=<? echo nl2br($myrow["word"]);;?'><font size=\"2\"><? echo $myrow["word"]?></font></a> = <? echo $myrow["cost"]?><BR>
<?
	}
?>

I get one link that looks like this... one<br />two<br />three

I should get 3 links, one of each of those words in each..

And yes, the same way it is added thru textarea

Frederick

$query="SELECT word, cost from kwords ORDER BY cost DESC LIMIT 100"; 
$result = mysql_query($query) or die("Query failed");
$myrow = mysql_fetch_array($result);

$content = explode("\n", $myrow["word"]);

foreach($content as $value) {
	echo "<a href=\"list.php?kword=$value\">".$myrow["cost"]."</a><br>";
}

slimjim

SO what did it ?

Was it the for each as

and the explode ?

I thought it had to be explode, but couldnt get it to work the way it should.

Thanks a million, will practice that to make sure I learn what you just taught me..

Frederick

When you use explode(), it places each line into an array element, so you have to use a foreach or while loop to call each item.
The \n indicates the end of each element and to start a new one.

You ca use this example also:

$str = "one, two, three";
$content = explode(",", $str);