how to use explode() and separate 2 links??

ngu_tri

hello everyone. I inserted 2 or more than 2 web links at the same field. So how can i use explode() function to separate them?? Thanks

<?php

include("dbconnect.php");
$result = mysql_query("select * from media");

if ($result)

{

while ($row = mysql_fetch_array($result))

{

?>
Tittel_ID:
Nettlink:
<a target="_blank" href="<? echo $row[Nettlink]; ?>">
<? echo $row['Nettlink']; ?></a>
 
 
<?php
}

mysql_free_result($result);

}
?>

devinemke

how are the links separated? can you post an example of what a media.Nettlink value looks like?

ngu_tri

hello

explode() for comma ","
Look at this link http://kg.out-force.com/listeopp.php (a big list, search aftter www) for more understandable. Thanks

<?php include("dbconnect.php"); ?>
<?php
$result = mysql_query("select * from media");
if ($result)
{
while ($row = mysql_fetch_array($result))
{
print "Tittel_ID:";

print "Nettlink:";
print "<a target=_blank href='$row[Nettlink]'>$row [Nettlink]</a>";
print " \n";
print " \n";
}
mysql_free_result($result);

}

for example I inserted 3 weblinks into mysql for field Nettlink: http://www.nrk.no/katta, http://www.bion.no/tema/kloning.shtml, http://www.yahoo.com

when I click on one of these links, so it should be showed up new window for only one link, NOT DISPLAYS ALL 3 LINKS = ERROR.

devinemke

from your site it looks like a comma followed by a space.

$links = explode(', ' $links);

ngu_tri

could you please show more clearly? Thanks

how can i put $Nettlink= explode(', ' $Nettlink) inside this code??

print "<a target=_blank href='$row[Nettlink]'>$row [Nettlink]</a>";

devinemke

$Nettlink = explode(', ', $row['Nettlink']);
foreach ($Nettlink as $value)
{
	echo '<a target="_blank" href="' . $value . '">' . $value . '</a><br>';
}

TheDefender

Just to twist things around a bit, because I am not sure how they are actually being inputted, but I imagine they could get more than one space in them, so I would personally explode at the comma and trim the results to remove the whitespace.

$Nettlink = explode(',', $row['Nettlink']); 
foreach ($Nettlink as $value) 
{ 
    echo '<a target="_blank" href="' .trim( $value) . '">' . trim($value) . '</a><br>'; 
}

But that's just me....

ngu_tri

Thank you . It is working