pulling data from array

From: Date: Mon, 08 Sep 2008 18:55:12 +0000
Subject: pulling data from array
Groups: php.general 
Request: Send a blank email to php-general+get-279688@lists.php.net to get a copy of this message
I am trying to pass the data from a table to a google.visualization.OrgChart javascript I have converted the data to an array called $customf_array. Look down in the script to where I need to pull the data out of the array to see the reset of my question $query = "SELECT * FROM member WHERE members_id = '$_SESSION[members_id]'"; $result=mysql_query($query); $row = mysql_fetch_array($result); $memberrep=$row['repnumber']; $query1 = "SELECT sponserrep,rep,firstname,lastname,phonenumber FROM contacts WHERE members_id = '8' AND sponserrep != ''"; $result1=mysql_query($query1); $num_rows = mysql_num_rows($result1); while($row1=mysql_fetch_array($result1)){ $customf_array[]=$row1[0] . "," . $row1[1] . "," . $row1[2] . "," . $row1[3]; } foreach ($customf_array as $value) { echo "Value: $value<br />\n"; } this is the data that is put out by the foreach Value: 0000,1234,top,manager Value: 1342,4523,Leeann,Rodriguez Value: 4325,1111,Carolyn,Sanderssandifer Value: 1342,4567,Annie B,Scott Value: 1234,4325,Jessica,Hobirk Value: 1234,12356,Kaye,Meadows Value: 1234,1342,Misty,Coe Value: 1234,3462,Donald,Skinner ?> <html> <head> <script type="text/javascript" src="http://www.google.com/jsapi"></script> <script type="text/javascript"> google.load("visualization", "1", {packages:["orgchart"]}); google.setOnLoadCallback(drawChart); function drawChart() {
       var data = new google.visualization.DataTable();
       data.addColumn('string', 'Name');
       data.addColumn('string', 'Manager');
                     data.addRows(<? echo $num_rows?>);
       data.setCell(0, 0, '<? echo$row["firstname"]?> <? echo$row["lastname"]?>','<font size="+1" color="#FF0000"><? echo$row["firstname"]?> <? echo$row["lastname"]?>           </font><br><? echo$row["phonemember"]?>');
<*****************************look at this section***********************> This is what I do not understand how to do if you can give me some examples on how to sort and pull this data out of the array or if there is a better way to do this I have been working with this for a few days and do not no where to go This is the section I need to loop through the array and add the data it needs to number each recored and the add the members name according to the rep# and the managers name according to the sponserrep# $number //the recored number $addname // the members name $addmanager// the managers name
              data.setCell($number, 0, '$addname','<h1>$addname</h1>');               data.setCell($number, 1, '$addmanager');
<*****************************l***********************>
       var table = new
google.visualization.OrgChart(document.getElementById('chart_div'));
       table.draw(data, {allowHtml:true});
} </script></head> <body><div id="chart_div"></div></body> </html>

« previous php.general (#279688) next »