I know I'm just being blind...

[mohamed42]

So I've got a bit of code that grabs stuff from a database and does some parsing. Take a look:

$children = mysql_query($query) or die ("Unable to find children of node: ".mysql_error());

  if(mysql_num_rows($children) > 0) {
    echo ("<children>");
    while($child = mysql_fetch_row($children)); {
      echo ("id= ".$child);
      process_node($child);
    }
    echo ("</children>");
  }

The problem I'm running into is that when $child is passed to process_node (which is, incidentally, the name of the function that holds the code you're looking at,) it has no value. I know that results are getting returned 'cause I've echoed the result of mysql_num_rows. It just seems like for some reason $child isn't getting set - I've tried adding a print_r($child) and that doesn't even show up on the page, and the echo ("id=... is just blank.

Can anyone see what I'm missing here? Thanks in advance for your help.

[keith73]

$child is an array containing the data in the fields of the database. In order to access that information, you need to access it as an array.

use mysql_fetch_assoc or mysql_fetch_array instead of mysql_fetch_row, fetch_row only gives you an array indexed by # and you'd have to keep track of the order of the columns returned.

change these lines.

while($child = mysql_fetch_assoc($children)){
      echo ("id= ".$child['id_column_name']);
      process_node($child['id_column_name']);
}

also, remove the semi-colon from the while statement.

• keith

[mohamed42]

It was the semicolon that did it - I'd messed around with pretty much every iteration of mysql results handling out there, but always with the semicolon. Thanks!