[Resolved] multiple value in a field

[sirTemplar]

hi again.

i have these fields: email and url. these should display an email add and the url. my problem lies when i have two or three values (eg. two email adds or 2 urls)! they are highlighted as one!

my html to display the value is:

<td align=left width=80% valign=top><font face=Verdana size=2 color=#000000><a href='mailto:{$row['EMAIL']}'>{$row['EMAIL']}

and

<td align=left width=80% valign=top><font face=Verdana size=2 color=#000000><a target=_blank href='{$row['URL']}'>{$row['URL']}

what do i need to do to highlight them separately, i.e. to make them cliccable separately!

[DangerousDave86]

You need some more code (if this hasn't been resolved already).
what i would suggest is using the explode function to split the string in two where it finds a space, example:

if (strpos($row['EMAIL']," ") !== FALSE) {
  $EMAILS = explode(" ",$row['EMAIL']);
  foreach ($EMAILS as $EMAIL) {
    print "<td align=left width=80% valign=top><font face=Verdana size=2 color=#000000><a href='mailto:{$EMAIL}'>{$EMAIL}</a>";
  }
}
else {
  print "<td align=left width=80% valign=top><font face=Verdana size=2 color=#000000><a href='mailto:{$row['EMAIL']}'>{$row['EMAIL']}</a>";
}

You can use the same code for the URLS, just change the appropriate variable names.
A word of warning though, if the amount of EMAILS and URLS are not the same your tables may mess up

--- Dave

[sirTemplar]

still can't get it to work.

here again is the present code:

if (isset($row["E_MAIL"]) && strcasecmp($row["E_MAIL"],""))
{
echo "<table bgcolor=#FFFEEF border=0 cellpadding=1 cellspacing=0 style=border-collapse: collapse bordercolor=#111111 width=100%>
<tr><td align=left width=80% valign=top><font face=Verdana size=2 color=#000000><a href='mailto:{$row['E_MAIL']}'>{$row['E_MAIL']}</td></table>";
}

[DangerousDave86]

How are the emails and urls seperated in the field, by a space?
Play around with the code sample i gave earlier, just alter the variable names

[sirTemplar]

thanks for the help but...

this is my code now:

if (isset($row["E_MAIL"]) && strcasecmp($row["E_MAIL"],""))

if (strpos($row['E_MAIL']," ") !== FALSE) {
$E_MAILS = explode(" ",$row['E_MAIL']);
foreach ($E_MAILS as $E_MAIL) {

echo "<table bgcolor=#FFFEEF border=0 cellpadding=1 cellspacing=0 style=border-collapse: collapse bordercolor=#111111 width=100%>
<tr><td align=left width=80% valign=top>
<font face=Verdana size=2 color=#000000>
<a href='mailto:{$E_MAIL}'>{$E_MAIL}</a></td></table>";
}
}
else {
echo "<table bgcolor=#FFFEEF border=0 cellpadding=1 cellspacing=0 style=border-collapse: collapse bordercolor=#111111 width=100%>
<tr><td align=left width=80% valign=top>
<font face=Verdana size=2 color=#000000>
<a href='mailto:{$row['E_MAIL']}'>{$row['E_MAIL']}</a></td></table>";
}

this outputs the content of the e_mail field on my database. on my database field e_mail, the emails (if more than one are separated by a space). the above codes prints something like this:

siTemplar
[e-mail]
[e-mail]

what i want is to make it appear like this:

siTemplar
[e-mail] , [e-mail]

with the two emails next to each other and both active. thanks.

[sirTemplar]

i was already able to resolve the problem!

thanks anyway! such a big help pal! ciao!