I have a multiple select box with contact names and phone numbers. When you select a name that has “Investors” in front of it, I want it to display all the Names and phone numbers, but only show the word Investors once. For example, I want it to look like this:
Invesors: Name Phone Number, Name2, Phone Number 2
Here is the code I am using to seperate the value by a comma:
<? foreach($contacts as $value) {
list ($id, $info) = split (“,”, $value);
echo “<input type=hidden name=contacts[] value=$id,$info>n”;
}?>
Then here is the code I am using to display the data:
<?
echo “Contacts:”;
foreach($contacts as $value) {
list ($id, $info) = split (“,”, $value);
$info = str_replace(“~”, “ ”, $info);
$inv = substr(“$info”, 0, 9);
//while ($inv == “Investors”) {
// echo “<p>” . $info . “, ”;
//}
if ($inv == “Investors”) {
echo “<p>” . $info . “ or <a href=mailto:[email protected]>[email protected]</a></p>”;
} else {
echo “<p>” . $info . “</p>”;
}
}
?>
But this gives me the following result:
Investors: Name Phone Number
Investors: Name2 Phone Number
Any help would be greatly appreciated
[code=php]<?PHP
$x = 0;
echo "Contacts:";
foreach($contacts as $value) {
list ($id, $info) = split (",", $value);
$info = str_replace("~", " ", $info);
$invinfo = substr($info, 11, -1);
$inv = substr("$info", 0, 9);
if ($inv == "Investors") {
if ($x == 0) {
echo "<p>Investors: " . $invinfo . " or <a href=mailto:[email protected]>[email protected]</a></p>";
$x = 1;
}
else {
echo "<p>" . $invinfo . " or <a href=mailto:[email protected]>[email protected]</a></p>";
}
}
else {
echo "<p>" . $info . "</p>";
}
}
?>[/code]
[code=php]if ($inv == "Investors") {
if ($x == 0) {
echo "<p>Investors: " . $invinfo . " or <a href=mailto:[email protected]>[email protected]</a>,";
$x = 1;
}
else {
echo " " . $invinfo . " or <a href=mailto:[email protected]>[email protected]</a>,";
}
}
else { [/code]
[code=php]<?PHP
$invvals = "";
$infovals = "";
$contacts = file("array.txt");
echo "Contacts:";
foreach($contacts as $value) {
list ($id, $info) = split (",", $value);
$info = str_replace("~", " ", $info);
$invinfo = substr($info, 11, -1);
$inv = substr("$info", 0, 9);
if ($inv == "Investors") {
$invvals .= $invinfo." ";
}
else {
$infovals .= $info;
}
}
echo "<p>Investors: $invvals <a href=mailto:[email protected]>[email protected]</a></p>";
echo "<p>$infovals <a href=mailto:[email protected]>[email protected]</a></p>";
?>[/code]
[code=php]$invvals = substr($invvals, 0, -2);[/code]
<?
$sql="SELECT EVT.ITEM_NBR, EVT.TITLE_TXT,
EVT.BODY_TXT, REF.ID, INF.FIRST_NME, INF.LAST_NME, INF.PHONE_NBR,
INF.DEPARTMENT
FROM SYSADM.INDYH_DYNCONTENT_HTML EVT,
SYSADM.INCOR_CONTACT_REF REF,
SYSADM.INCOI_CONTACT_INFO INF
WHERE EVT.ITEM_NBR = $item_nbr
AND EVT.ITEM_NBR = REF.ITEM_NBR
AND REF.ID = INF.ID
ORDER BY DEPARTMENT, INF.LAST_NME";
$D->my_sel($sql);
//print $sql;
if ($D->numrows > 0) {
echo "<p>Contacts:</p>";
for($i=0; $i< $D->numrows; $i++) {
$first_nme=$D->results["FIRST_NME"][$i];
$last_nme=$D->results["LAST_NME"][$i];
$phone_nbr=$D->results["PHONE_NBR"][$i];
$department=$D->results["DEPARTMENT"][$i];
if ($department == "Investors") {
if ($first_nme == "0") {
$contact_info = "<p>" . $department . ": " . $phone_nbr . " or <a href=mailto:[email protected]>[email protected]</a></p>";
} else {
$contact_info = "<p>" . $department . ": " . $first_nme . " " . $last_nme . " " . $phone_nbr . " or <a href=mailto:[email protected]>[email protected]</a></p>";
}
} else {
$contact_info = "<p>" . $department . ": " . $first_nme . " " . $last_nme . " " . $phone_nbr;
}
}
?>
$sql="SELECT EVT.ITEM_NBR, EVT.TITLE_TXT,
EVT.BODY_TXT, REF.ID, INF.FIRST_NME, INF.LAST_NME, INF.PHONE_NBR,
INF.DEPARTMENT
FROM SYSADM.INDYH_DYNCONTENT_HTML EVT,
SYSADM.INCOR_CONTACT_REF REF,
SYSADM.INCOI_CONTACT_INFO INF
WHERE EVT.ITEM_NBR = $item_nbr
AND EVT.ITEM_NBR = REF.ITEM_NBR
AND REF.ID = INF.ID
ORDER BY DEPARTMENT, INF.LAST_NME";
$D->my_sel($sql);
//print $sql;
if ($D->numrows > 0) {
echo "<p>Contacts:</p>";
for($i=0; $i< $D->numrows; $i++) {
$first_nme=$D->results["FIRST_NME"][$i];
$last_nme=$D->results["LAST_NME"][$i];
$phone_nbr=$D->results["PHONE_NBR"][$i];
$department=$D->results["DEPARTMENT"][$i];
if ($department == "Investors") {
if ($first_nme == "0") {
$contact_info = "<p>" . $department . ": " . $phone_nbr . " or <a href=mailto:[email protected]>[email protected]</a></p>";
} else {
$contact_info = "<p>" . $department . ": " . $first_nme . " " . $last_nme . " " . $phone_nbr . " or <a href=mailto:[email protected]>[email protected]</a></p>";
}
} else {
$contact_info = "<p>" . $department . ": " . $first_nme . " " . $last_nme . " " . $phone_nbr;
}
?>
<font face="Arial, Helvetica, sans-serif">
<?=$contact_info?>
<?}
}?>
[code=php]$contact_info = "";
$contact_info2 = "";
if ($department == "Investors") {
if ($first_nme == "0") {
$contact_info .= $department . ": " . $phone_nbr;
}
else {
$contact_info .= $department . ": " . $first_nme . " " . $last_nme . " " . $phone_nbr;
}
}
else {
$contact_info2 .= $department . ": " . $first_nme . " " . $last_nme . " " . $phone_nbr;
}
echo "<p>$contact_info <a href=mailto:[email protected]>[email protected]</a></p>";
echo "<p>$contact_info2 <a href=mailto:[email protected]>[email protected]</a></p>";[/code]
for($i=0; $i< $D->numrows; $i++) {
$first_nme=$D->results["FIRST_NME"][$i];
$last_nme=$D->results["LAST_NME"][$i];
$phone_nbr=$D->results["PHONE_NBR"][$i];
$department=$D->results["DEPARTMENT"][$i];
$contact_info = "";
[code=php]$contact_info = "";
$contact_info2 = "";
if ($department == "Investors") {
if ($first_nme == "0") {
$contact_info .= $phone_nbr;
}
else {
$contact_info .= $first_nme . " " . $last_nme . " " . $phone_nbr;
}
}
else {
$contact_info2 .= $first_nme . " " . $last_nme . " " . $phone_nbr;
}
echo "<p>Investors: $contact_info <a href=mailto:[email protected]>[email protected]</a></p>";
echo "<p>Media: $contact_info2 <a href=mailto:[email protected]>[email protected]</a></p>";[/code]
[code=php] if ($D->numrows > 0) {
echo "<p>Contacts:</p>";
for($i=0; $i< $D->numrows; $i++) {
$first_nme=$D->results["FIRST_NME"][$i];
$last_nme=$D->results["LAST_NME"][$i];
$phone_nbr=$D->results["PHONE_NBR"][$i];
$department=$D->results["DEPARTMENT"][$i];
$contact_info = "";
$contact_info2 = "";
if ($department == "Investors") {
if ($first_nme == "0") {
$contact_info .= $phone_nbr;
}
else {
$contact_info .= $first_nme . " " . $last_nme . " " . $phone_nbr;
}
}
else {
$contact_info2 .= $first_nme . " " . $last_nme . " " . $phone_nbr;
}
} //end for loop
} //end If $D->numrows > 0 loop
echo "<p>Investors: $contact_info <a href=mailto:[email protected]>[email protected]</a></p>";
echo "<p>Media: $contact_info2</p>";
[/code]
[code=php]$contact_info = "";
$contact_info2 = "";
if ($D->numrows > 0) {
echo "<p>Contacts:</p>";
for($i=0; $i< $D->numrows; $i++) {
$first_nme=$D->results["FIRST_NME"][$i];
$last_nme=$D->results["LAST_NME"][$i];
$phone_nbr=$D->results["PHONE_NBR"][$i];
$department=$D->results["DEPARTMENT"][$i];
if ($department == "Investors") {
if ($first_nme == "0") {
$contact_info .= $phone_nbr;
}
else {
$contact_info .= $first_nme . " " . $last_nme . " " . $phone_nbr;
}
}
else {
$contact_info2 .= $first_nme . " " . $last_nme . " " . $phone_nbr;
}
} //end for loop
} //end If $D->numrows > 0 loop
echo "<p>Investors: $contact_info <a href=mailto:[email protected]>[email protected]</a></p>";
echo "<p>Media: $contact_info2</p>";[/code]
0.1.9 — BETA 6.17