PHP - Simplexml Array Problems

i have a users online section and i am using an aray and implode so the comma is displayed on every username but the last, but it displays the same usernames several times. This could be due to the switch i am using to define user group. Heres the code:

$online_query = $db->query("SELECT user_id, user_group, user_username
                            FROM ".DB_PREFIX."sessions");
while ($online_info = mysql_fetch_object($online_query)) {

switch($online_info->user_group)
        {
            case 1:
                $userClass = 'admin';
                break;
            case 2:
                $userClass = 'mod';
                break;
            case 3:
            case 0:
            default:
                $userClass = 'user';
                break;
        }

$users2[] = "<span class=\"{$userClass}\">{$online_info->user_username}</span>"; 

echo '<p>' . implode(', ', $users2) . '</p>';
}

is there something i am doing wrong?

The code here is suppose to allow the user to match up a word ($word) with a list of definitions ($word_defs).  I can't get the list of definitions to stick.  When the user does make a guess it shows that he is always correct.  How can i fix these problems?

 Outside entry code:
Code: [Select]
<?php
require_once "include/session.php";
require_once "include/word_defs.php";
 
$word = array_keys($word_defs); 
$word_defs = array_unique(array_values($word_defs));

$params = (object) $_REQUEST;
$session = new Session();
 
if (isset($params->guess)) {
  $word = $params->word;
  if ( $params->word == $word_defs[$term] ) {
    $response = "correct"; 
  } else {
    $response = "incorrect"; 
  }
  $choices->word_def[$params->word_def] = "selected";
} else {
  $word = $word[ rand( 0, count($word)-1 ) ];
}
?>

Body code:

Code: [Select]
word: <?php echo $word ?>


<form action="?" method="get">
definition:
<select name="word_defs">
<?php foreach ($word_defs as $word_def): ?>
<option <?php echo $choices->word_def[$word_def] ?> ><?php echo $word_def?></option>
<?php endforeach ?>
</select>
 
<input type="submit" name="guess" value="Guess" />
 
<input type="hidden" name="word" value="<?php echo $word?>" />
</form>

<h3><?php echo $response ?></h3>

I'd like some help debuging my code, I can't seem to figure out why it isn't creating the variables... Here it is:


<?php
$template_settings = array(
"index"=>"index.php",
"announcements"=>"announcements.php"
);

extract($template_settings, EXTR_PREFIX_ALL, "template_");
echo $template_index;
?>


No matter what I do $template_index still equals null and I'm wondering what I'm doing wrong. There are no errors of anykind.

I have a db table with 1500 street names inside - id, tfare, ptown, pcode, area.

The 'area' column is specific to the company i work for and each street belongs to an 'area' number defined by the company.

Currently each area is '0' - unassigned. The company areas are numbered 1 - 18. I need to list each street (LIMIT 10 at a time), and have an input box for the area to be edited and saved.

The following code works perfectly well when dealing with 1 record at a time (LIMIT 0, 1), but breaks when i change the LIMIT to 10.

I'm trying to show the dinosaur management that we need to upgrade our paper, yes, paper system to computers. I'm a transport manager, but in my spare time since 2004 I'm fluent in HTML and CSS, but only in the last few months really decided to give PHP and MySQL a *real* go.

I'm 'guessing' I need to look into arrays for this to work? I've tried searching about but I dont even know how to articulate what i need to search for, so I have to publicly ask for help via this long winded post, sorry

Here is my code:



<?php

include($_SERVER['DOCUMENT_ROOT'].'/!SYSTEM/bootstrap.php');

if(isset($_POST['savearea']))
{
    $id = $_POST['hideID'];
    $area = $_POST['area'];
   
    $sql = "UPDATE bmth_streetindex SET area='$area' WHERE id='$id'";
   
    if ($query = mysql_query($sql)or die(mysql_error()))
        {
         print "saved ???";
        }
}

    // grab data from bmth street index where the area is = 0 (which means its area is un-assigned)
    $sql = "SELECT * FROM bmth_streetindex WHERE area='0' LIMIT 0, 10";
    $rs = mysql_query($sql) or die(mysql_error());


print $HTML::form('action="" name="inputAreaForm" method="POST"')."\n\n";
   
    // 'while' thru and print them 1 at a time
    while($row = mysql_fetch_array($rs))
    {
        $id = $row['id'];
        $tfare = $row['tfare'];
        $ptown = $row['ptown'];
        $pcode = $row['pcode'];
        $area = $row['area'];
        $urlQ = $tfare. ", " .$ptown. ', ' .$pcode;
       
        print "<div>\n";
       
            print "\n<input type=\"hidden\" name=\"hideID\" value=\"$id\">";
           
            print "\n[$id] $tfare, $ptown, $pcode &nbsp;&nbsp;&nbsp;";
            print "\nArea <input type=\"text\" name=\"area\" value=\"$area\" />";
            print "\n<input type=\"submit\" name=\"savearea\" value=\"Save Area\">";
           
            print "\n<a href=\"http://www.google.com/maps?q=$urlQ&hl=en&ie=UTF8&z=17\" target=new>SHOW ON MAP</a>";
           
        print "\n<>\n<hr>\n\n";
    }

print $HTML::endForm();


?>




Thank you for taking the tie to read this, I hope someone can point me in the right direction for what i need to look into making this work

Problem: my checkbox array chkBrand[] is not saving data when I click the save button called cmdSave. Each checkbox specifies a brand connected to a model number. Multiple brands can be connected to each model number. (Don't ask, it's what the customer wants.)

So, if I check the checkbox in row 0 and row 3, only row 0 shows up. If I check the boxes in row 0, 1, 5, only rows 0, 1 show up in chkBrand and $newchkbrandarr.

First, my routine to see which button is checked is at the top of the php file. Here it is.

else if (isset($_POST['cmdSave'])) //Try to save items first.
    {
$newchkbrandarr=$_POST['chkBrand']; //Checkbox for each brand.
$oldchkbrandarr=$_SESSION['oldchkbrandarr'];
$olddata=$_SESSION['olddata']; //Non-brand Fields strung together.
$brandlist=$_SESSION['brandlist']; //List of brands displayed.

crPrintarr('chkBrand raw',$_POST['chkBrand']); //DEBUG. Prints array to screen.
//===At this point chkBrand[] contains: 1

//Turn nulls in checkboxes to zeros.
$cnt=count($newchkbrandarr);
for ($j=0; $j<$cnt; $j++)
{
$newchkbrandarr[$j]=$newchkbrandarr[$j]+0;
} //for j

//Make sure that at least one brand is checked.
$cnt=count($newchkbrandarr);
crPrintarr('newchkbrandarr',$newchkbrandarr); //DEBUG
//===At this point, $newchkbrandarr contains: 1, 0

$s='Elements in newchkbrandarr cnt='.$cnt;
$s.=', count brandlist='.count($brandlist);
crDebug($s); //DEBUG
$cnt2=0;
$cnt=count($newchkbrandarr); //Find number of elements.
for ($j=0; $j<$cnt; $j++)
{
$cnt2=$cnt2+$newchkbrandarr[$j]+0;
//$s='arrpos '.$j.': newchkbrandarr='.($newchkbrandarr[$j]+0).', cnt2='.$cnt2;
//crDebug($s); //DEBUG
} # for j


Here is my code to construct the array of checkboxes, one per table row. Each checkbox has its array position explicitly defined as $x. $x starts at zero, and is incremented by 1 for each table row (each check box).


    $x=0;
    while ($row = mysqli_fetch_array($result)) 
     {
$br=trim($row['brand']); //Brand name to display
$brandvar=$br;
$brandlist[]=$br; //Save every found brand for later.
//First find if brand is checked on table "brands". 
        $query2 = "SELECT brand ".
        "FROM brands ".
        "WHERE ".
        "(partid=".$partidvar.") ".
        "AND (brand='".$br."') ".
        "ORDER BY brand ".
        ";";
        $cntchk=crqryCount($query2,false); //If $cntchk>0 then brand is checked.
        //$s="Is brand stored already? <br/>$query2";
        //crDebug($s); //DEBUG
        
        $query2 = "SELECT brand ".
        "FROM zzbrands ".
        "WHERE (brand='".$br."') ".
        "AND (prodnameoverride=1) ".
        "ORDER BY brand ".
        ";";
$override=crqryCount($query2,false); //Can this brand override product name?

$s="\n";
     $s.='<tr><td>'.
         '<input type="text" value="'.$br.'" id="txtBrand[]" name="txtBrand[]" '.
         'size="20" readonly class="mydisabled" />';
     $s.='<td align="center">';
     $s.='<input type="checkbox" name="chkBrand['.$x.']" '.
         'id="chkBrand['.$x.']" value="1" ';
     if ($cntchk>0)
     {
     $s.='checked="checked" ';
     $oldchkbrandarr[$x]=1;
     }
     else {
     $oldchkbrandarr[$x]=0;
     }
     $s.='/>';


Any ideas what I might be missing?

Having problem with a bit of code.   I am trying to fetch data from the database, I have used mysql_fetch_array before, and even in later bits of code.  I want to use this data for an IF statement later on.  The IF statement isn't there, because this code is catching somewhere.  The fetch array is working fine, and it echos out the correct row in database that it should.  The issue, it stops displaying code that follows it.   

In the code, I have put a comment (// Code kills here ....) where the code is killing.  I have identified the few lines of code that is killing the script.

You can see the page.. The number 71 is what is supposed to be supplied by the query and array.  This is the page as it is with the trouble code. 



Here is the page without the trouble bit of code, and it displays all that it should.  But it doesn't have the functionality I want to build in with the array obviously.




Here is the code with highlight bit of trouble:

/source/userinfo.php
Code: [Select]
<?php
include ("db.php");


$get_info = mysql_query ("SELECT * FROM registrations WHERE u_id=$uid AND appid=$appid" , $link2);

//Begin Trouble Code

while ($check = mysql_fetch_array($get_info))
{

echo $check['assign_id'];

}

//End Trouble Code

// Code kills here, for some reason....  Proper assign_id displayed, but it kills script.




$count = mysql_num_rows($get_info);


if ($count >= 1)

{

$get_jos_info = mysql_query ("SELECT * FROM jos_users WHERE id=$appid" , $link);

$get_avatar = mysql_query ("SELECT * FROM jos_comprofiler WHERE user_id=$appid" , $link);


while ($avatar_link = mysql_fetch_array($get_avatar))

$avatarurl = $avatar_link['avatar'];

echo $avatar_link['avatar'];
echo "<table border='0' width='70%' align='center' cellpadding=5>";
 
while ($rowteam = mysql_fetch_array($get_info))
{

while ($rowjos = mysql_fetch_array($get_jos_info))
{
$urlbegin = "<img src='http://versionxlegends.com/images/comprofiler/tn";
$urlend =  "'>";

echo "<tr><td width=100% align=center colspan=2>".$urlbegin.$avatarurl.$urlend."</td></tr>";

echo $avatar;




echo "<tr><td width=40% align=right><strong>Registration #</strong></td><td width=60% align=center>$rowjos[id]</td></tr>";

echo "<tr><td width=40% align=right><strong>User's Username</strong></td><td width=60% align=center>$rowteam[username]</td></tr>";

echo "<tr><td width=40% align=right><strong>User's Name</strong></td><td width=60% align=center>$rowteam[name]</td></tr>";

echo "<tr><td width=40% align=right><strong>Provided Skype Username</strong></td><td width=60% align=center>$rowteam[skype]</td></tr>";

//Add script for lead only view Email Address.  Team Member, field is hidden.  Lead sees email and a YES/NO if email matches.  If not, lead will email user to get email verification, to edit account before assignments occur.

echo "<tr><td width=40% align=right><strong>E-Mail Address</strong></td><td width=60% align=center>$rowteam[email]</td></tr>";

echo "<tr><td width=40% align=right><strong>Registration Date</strong></td><td width=60% align=center>$rowjos[registerDate]</td></tr>";

// Add script for lead only view age.  Team Member, field is hidden.  Lead sees birthdate and/or age and a YES/NO if age matches.  If not, lead will email user with ID verification e-mail, to verify age before assignments occur.
echo "<tr><td width=40% align=right><strong>Age</strong></td><td width=60% align=center>$rowteam[age]</td></tr>";





}}


echo "</table>"; 

}
else

{ 

echo "Invalid URL.  Registration does not exist";

}



?>
This code is included within this page:

viewregistration.php

Code: [Select]
<?php 
session_start();

 $user_id = $_SESSION['user_id']; 
 $uid = $_GET['u_id']; 
 $appid= $_GET['appid'];

include ("db.php");

$get = mysql_query ("SELECT * FROM registrations WHERE u_id = $uid AND appid=$appid", $link2);

echo $get;

 ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252" />
<title>Nuke Ice By ThemeKings</title>
<link rel="stylesheet" type="text/css" href="nuke-ice.css" />







</head>
<body>
<div id="wrapper">


<div id="banner">
<div id="banner-edit"></div>
</div>


<div id="container">


<?php
include ("sidebar.php");

?>




<div id="col-2">
<?php
$uid = $_GET['uid']; 
$appid= $_GET['appid'];
 
?>

<div class="CntBox">
<div class="CntHead">
<div class="CntHeadInfo">User Information</div>
</div>
<div class="CntFill">
       
<div class="CntInfo">
<?php  include ("./source/userinfo.php");

 ?>
</div>
</div>
<div class="CntFooter"></div>
</div>
I included this bit of code so you can see some of the variables that were assigned in another file.

I have a text field in my database that I'm pulling the contents of and parsing into an array, at which point depending on the users action I'm either adding to the end or searching for a specific value and removing it.  I'm then converting the array back to a string and placing it back into the text field in the database.

Everything works fine except for either an empty array value or a new line forcing its way to the front. Causing, naturally an empty value loaded onto the page that displays this part of the db.

While I know theres a couple things in there that aren't necessary I was just too lazy to take them out before posting after attempting to find a way around this problem. But here is the bulk of the code.  I appreciate any help!

$to_add = "SELECT * FROM teams WHERE name = '$teamname'";
$que_to_add = mysql_query($to_add);
while ($fetch_members = mysql_fetch_array($que_to_add, MYSQL_BOTH)) {
$members = explode("\n", $fetch_members['members']);
$members = array_filter($members);
foreach ($members as $key => $value) {
$value = trim($value);
$new_insert[] = $value;
}
}
$new_insert = array_filter($new_insert);
foreach ($new_insert as $key => $value) {
if ($value != "") {
$to_insert = ($to_insert . "\n" . $value);
}
}
$to_insert = ($to_insert . "\n" . $for_insert);
$insert_ready = "UPDATE teams SET members = '$to_insert' WHERE name = '$teamname'";
$insert = mysql_query($insert_ready);

Hi,  I'm new to php and coding in general.  I'm trying to parse xml from a remote device and access specific value data.

Here is the xml:

<?xml version="1.0" encoding="ISO-8859-1" ?>
- <Device id="S10011" hb="1935">
  <Group id="1" />
  <Group id="2" />
  <Group id="3" />
  <Group id="4" />
  <Group id="5" />
  <Group id="6" />
  <Group id="7" />
  <Group id="8" />
- <Group id="9">
- <Probe id="99">
  <Value>1.0</Value>
  </Probe>
- <Probe id="1">
  <Value>86.4</Value>
  </Probe>
- <Probe id="2">
  <Value>45.7</Value>
  </Probe>
- <Probe id="3">
  <Value>2.9</Value>
  </Probe>
- <Probe id="4">
  <Value>1.0</Value>
  </Probe>
  </Group>
  </Device>
-----------------------
Here is my php code to read in the xml:
<?php
   // Establish a port 80 connection
   $http = fsockopen("192.168.2.106",80);

   // Send a request to the server
   $req = "GET /xmldata HTTP/1.0\r\n";
   $req .= "Host: 192.168.2.106\r\n";
   $req .= "Connection: Close\r\n\r\n";
   fputs($http, $req);

   // Output the request results
   while(!feof($http)) {
      $data .= fgets($http, 1024);
   }
   // Close the connection
   fclose($http);
  
  $xml = simplexml_load_string($data);

print_r ($xml);

?> 

This yields the following data:
SimpleXMLElement Object ( [@attributes] => Array ( [id] => S10011 [hb] => 117546 ) [Group] => Array ( => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 1 ) => ) [1] => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 2 ) => ) [2] => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 3 ) => ) [3] => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 4 ) => ) [4] => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 5 ) => ) [5] => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 6 ) => ) [6] => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 7 ) => ) [7] => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 8 ) => ) [8] => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 9 ) [Probe] => Array ( => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 99 ) [Value] => 1.0 ) [1] => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 1 ) [Value] => 84.2 ) [2] => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 2 ) [Value] => 44.1 ) [3] => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 3 ) [Value] => 4.8 ) [4] => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 4 ) [Value] => 1.0 ) ) ) ) )

I would like to display group 9 probe 1 value for example and I cannot get it to work.  Any tips?

so the code is



<?php

$xml1 = "
<outer>
  <xml>
    <more_info>
     <user>
        <id>200</id>
        <name>CLUEL3SS</name>
    </user>
    <user>
        <id>201</id>
        <name>CLUEL3SS2</name>
     </user>
    </more_info>
  </xml>
</outer>    ";

$cwb = simplexml_load_string($xml1);
foreach($cwb->xml->more_info->user as $stats)
  {
   echo $stats->id."\n";}
   
?>




output is

Code: [Select]
200
201

Now, how can I echo the name under <id>201</id> since there is more than one?


echo $stats->id."\n";


That echos both of the "ID" values, now how can I get it to only echo the second id 201 and the second name?

Thanks

Ok so I have a url that is an XML doc, it says at the top

"This XML file does not appear to have any style information associated with it. The document tree is shown below."

and it has info like this

Code: [Select]

<outer>
  <xml>
    <viewer>
      <user>
        <id>1245789</id>
        <name>CLueless</user>
        <business>none</business>
      </user>
    </viewer>
  </xml>
</outer>


How would I load the link and then assign everything to a variable like id, name and business

I usually use something like this but Im trying to get learn simple xml



$info = file_get_contents('url');
$id = explode('<id>', $info);
$id = explode('</', $id[1]);
$name = explode('<name>', $info);
$name = explode('</', $name[1]);
$biz = explode('<business>', $info);
$biz = explode('</', $biz);

I'm having a problem trying to understand how to grab the following values,

<times>
<time type="join">1293756060</time>
<time type="leave">1293756420</time>
</times>

Ive read and tried everything I can find for a couple days now and cant get anything to grab both separate times
   foreach ($xml->times->time as $times){
   $timein{$num} = $times; //this grabs leave time, by accident im sure lol
   $timeout{$num} = ???????; //dont know how to separate them by join/leave.
}

any help would be great.

Hi, I don't know why the foreach loop doesn't output the text node content of <toFirstName> and <toLastName>?

please see email.xml file below:
Code: [Select]
  <?xml version="1.0" encoding="ISO-8859-1"?>
<email>
<message>
<to>
<toFirstName>Tove</toFirstName>
<toLastName toType="common" style="swag">Smith</toLastName>
</to>
<from>
<fromFirstName>Jani</fromFirstName>
<fromLastName fromType="unique">Dravison</fromLastName>
</from>
<heading>Reminder</heading>
<body>
<prologue>Tis the night before Xmas...</prologue>
<paragraph1>Don't forget me this weekend!</paragraph1>
<paragraph2>Jump the gun!</paragraph2>
<epilogue>The end of the world.</epilogue>
</body>
</message>
</email>

Please see script below:
=================
Code: [Select]
<?php
$simpleXMLObj=simplexml_load_file("email.xml");

foreach($simpleXMLObj->message[0]->to[0] AS $curDOM) {
print $curDOM->toFirstName->getName."<br />".$curDOM->toLastName->getName."<br />";
?>

Please help me out, I would really appreciate it! 

I have limited idea about SimpleXML but not with the code below and need to edit it so the results can be parsed into a html format. The problem i am having is the XML tags are stored in an existing variable returned from a third party server so need something that can parse this xml info into a html with tags being used.

Code: [Select]
$xml = "<Inputs>";
$xml.= "<Authentication>";
$xml.= "<Username>$username</Username>";
$xml.= "<Password>$password</Password>";
$xml.= "<RequestType>Term</RequestType>";
$xml.= "<RequestFrom>$system_name</RequestFrom>";
$xml.= "<RequestFromCode>$system_code</RequestFromCode>";
$xml.= "</Authentication>";

$xml.= "<Life1>";
$xml.= "<DOB>$dob</DOB>";
$xml.= "<Sex>$sex</Sex>";
$xml.= "<Smoker>$smoker</Smoker>";
$xml.= "<LifeCover>$lifecover</LifeCover>";
$xml.= "<IllnessCover>N</IllnessCover>";
$xml.= "</Life1>";

$xml.= "<Life2>";
$xml.= "</Life2>";

$xml.= "<Plan>";
$xml.= "<Term>$term</Term>";
$xml.= "<Indexation>N</Indexation>";
$xml.= "<MortgageInterest>6</MortgageInterest>";
$xml.= "<Frequency>Monthly</Frequency>";
$xml.= "<QuoteLifeOnly>Y</QuoteLifeOnly>";
$xml.= "<QuoteLifeAccelerated>$accelerated</QuoteLifeAccelerated>";
$xml.= "<QuoteLifeIllness>N</QuoteLifeIllness>";
$xml.= "<QuoteIllnessOnly>N</QuoteIllnessOnly>";
$xml.= "</Plan>";
$xml.= "</Inputs>";

$url = 'URL NORMALLY HERE';
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, "xml=".urlencode($xml));
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);
$xml_result=curl_exec($ch);
curl_close($ch);
print("[$xml_result]");

/* simple xml */
$simplexml = new SimpleXMLElement($xml_result);
$Name = $simplexml->Name;
echo $Name;
/* end */

$data = XML_unserialize($xml_result);
$xml_result contains... (with usernames/passwords removed)

Code: [Select]
<Result>
<Errors></Errors>
<Inputs><Authentication><Username>####</Username>
<Password>####</Password><RequestType>Term</RequestType><RequestFrom>####</RequestFrom><RequestFromCode>####</RequestFromCode></Authentication><Life1><DOB>01/01/1969</DOB><Sex>Male</Sex><Smoker>Non-Smoker</Smoker><LifeCover>100,000</LifeCover><IllnessCover>N</IllnessCover></Life1><Life2></Life2><Plan><Term>10</Term><Indexation>N</Indexation><MortgageInterest>6</MortgageInterest><Frequency>Monthly</Frequency><QuoteLifeOnly>Y</QuoteLifeOnly><QuoteLifeAccelerated>Non-Smoker</QuoteLifeAccelerated><QuoteLifeIllness>N</QuoteLifeIllness><QuoteIllnessOnly>N</QuoteIllnessOnly></Plan></Inputs><Outputs>
<Summary>
<Life1>Male, 40 years 8 months (01/01/1969), Non-Smoker, life cover 100,000</Life1>
<Life2></Life2>
<Plan>10 year term, mortgage interest 6.00%, benefits and premiums not increasing.<p>1% levy included.</p></Plan>
</Summary>
<Quotes>
<Type>
<Desc>Life Cover Only</Desc>
<Company>
<Name key="1">Caledonian Life</Name>
<PricePledge>False</PricePledge>
<Underwriting1></Underwriting1>
<SLevel key="2">14.50</SLevel>
<SConvertible key="2">15.46</SConvertible>
<SMortgage key="2">12.12</SMortgage>
</Company>
<Company>
<Name key="2">Canada Life</Name>
<PricePledge>False</PricePledge>
<Underwriting1></Underwriting1>
<SLevel key="2">15.15</SLevel>
<SConvertible key="2">15.91</SConvertible>
<SMortgage key="2">13.13</SMortgage>
</Company>
</Type>
</Quotes>
</Outputs>
</Result>
Any advice would be much appreciated