[RESOLVED] Stuck

donkeychoker

Hi all,
Could someone please shed light on my problem?

I have records in a mysql database and i want to echo them out but hyperlink to certain words it finds in a field.

MY CODE

$aboats=array("Artemis","Alaric","Ambush","Acheron","Trumph");
$splitdata = explode(',',$boats);

foreach ($splitdata as $key => $sub) {
if (in_array("$sub",$aboats)) {

echo"<span class=black><a href=../boats/$sub> $sub </a></span>";
}
else{
echo"$sub";
}

}

the $boat var is taken from the database and as a varchar in text. (i.e: Artemis,Acheron,Trafalgar etc....)

The above code works but only hyperlinks the first match it finds..........

Any help please?

devinemke

$boats = 'Alaric,Blah Blah Blah,Acheron';

$aboats = array('Artemis','Alaric','Ambush','Acheron','Trumph');
$splitdata = explode(',', $boats);

foreach ($splitdata as $value)
{
	if (in_array($value, $aboats)) {echo '<span class="black"><a href="../boats/' . $value . '">' . $value . '</a></span>';}
	else {echo $value;}
	echo '<br>';
}

donkeychoker

Hi , thx for reply... Your code is certainly 'cleaner' but is it not the same as mine?

Same result

devinemke

my code (as written) does in fact work. i suspect that your incoming $boats variable is not formatted exactly the same way as my example. perhaps there are spaces between each comma separated word? if so then read up on [man]trim[/man].

donkeychoker

Hi again,
I have tried trim and also updated the record to remove any spaces.
The actual $value or $sub as I had it echoes out ok but it is just the hyperlink that won't work past the first one.

I assume then that if your code works then I should look elsewhere.

I will double check and reply here..

Thanks again

donkeychoker

Oh !
this is the link to the page it links to...as you can see the last record should hyperlink another boat

http://dorsetsubmariners.org.uk/main/branch/members2.php

donkeychoker

Hi again, well it turned out that all that was wrong was that my css class that i used for the hyperlink was not in the correct order. The A:link must be in right order or only the first link works.
You learn something new everyday {puzzled}.

Thanks again for your help