
 Ericka10 - 2010-03-24 18:00:56
 
connect to mysql. I'm trying to connect to mysql demo2.php but only shows me the first record in the table. please help. I put the code here
<?php
/**
 *	phpTreeGraph
 *	Species hierarchy demo with images
  * 	@author Mathias Herrmann
**/
//include GD rendering class
require_once('./classes/GDRenderer.php');
 $connection = mysql_connect("localhost", "root", "123") or die (mysql_error());
mysql_select_db("sistrag", $connection) or die (mysql_error());
 
	  $result = mysql_query("select o.id_objetivo, o.padre, o.Nombre_objetivo from objetivo o where padre ='".$inicio."' ", $connection);
	
			if($row = mysql_fetch_array($result))
	{  $cantidad_filas = mysql_num_rows($result);
		 mysql_field_seek($result,0);
		    
  
			 do{
			 
			
//create new GD renderer, optinal parameters: LevelSeparation,  SiblingSeparation, SubtreeSeparation, defaultNodeWidth, defaultNodeHeight
$objTree = new GDRenderer(30, 10, 30, 350, 20);
//add nodes to the tree, parameters: id, parentid optional title, text, width, height, image(path)
$objTree->add($row['id_objetivo'] , $row['padre'] ,$row['Nombre_objetivo'] );
$objTree->setNodeLinks(GDRenderer::LINK_BEZIER);
$objTree->setBGColor(array(255, 183, 111));
$objTree->setNodeTitleColor(array(0, 128, 255));
$objTree->setNodeTitleColor(array(0, 128, 255));
$objTree->setLinkColor(array(0, 64, 128));
$objTree->setTextTitleColor(array(255, 255, 255));
$objTree->setFTFont('./fonts/Vera.ttf', 12, 0, GDRenderer::CENTER|GDRenderer::TOP);
$objTree->stream();} while($row = mysql_fetch_array($result));
    ?>	
	<?php
}?>