[SOLVED] ENCAPSED_STRING issue

[synking]

Hey guys i have this code. which steps through an adjacency table and prints hierarchal data. What i want to do is then turn that output into an anchor link on the page with maybe a list or something but i am having issues.

 

function display_children($parent, $level) {
require_once ('../includes/DbConnector.php');
$connector = new DbConnector();

   // retrieve all children of $parent
   $result = $connector->query('SELECT id, name, parentid FROM cmssection '.
                          'WHERE parentid="'.$parent.'";');
       if(!$result) {
      echo ('<p class="error">Error from query: ' .$connector->getSqlError(). '</p>');

       } else {

   // display each child
   while ($row = $connector->fetchArray($result)) {
       // indent and display the title of this child
       echo (str_repeat('  ',$level)'<a href="">'.$row['name'].'</a><br>');

       // call this function again to display this
       // child's children
       display_children($row['id'], $level+1);
   }

      }
}

  I get when doing this of course a T_CONSTANT_ENCAPSED_STRING warning which i know what creates it, but to print the function out properly i have to keep it as one echo i think but echo whould support multiple quotes correct, If so what am i doing wrong.

[efficacious]

this string is wrong

 

echo (str_repeat('  ',$level)'<a href="">'.$row['name'].'</a><br>');

 

should be like this:

 

echo(str_repeat(' ',$level) . '<a href="">' . $row['name'] . '</a><br />');

 

 

you were missing a '.' (period) after the str_repeat function

hope that helps

[synking]

That worked perfectly thanks i see i will pay more attention to periods now.

[efficacious]

don't feel bad I found it for you and I'm always forgetting a period here or a semi colon there. lol