[b]for loop problem..!!!![/b]

[avvishnu]

i need some help. i need to display the data in a table when i am clicking a details button. but in my code wont display the data in the table. i checked the button. its set. but the control didnt go to the forloop ( foreach($details as $vals) )

also i cant access any of the classID, clsname from inside the IF loop.

please help me to overcome this problem..
the code is here.

<?php

$classID=$_GET['className'];
$detailsinfo=$_GET['detailsinfo']; // Details info Button

function getMoreClassDetails($clsid)
{
  	 $ResultAllDetails=QrySelect("Select cls_id , cls_desc From sm_classdetails WHERE cls_id='$clsid'");  

	 $arrDetails=array();
	 while($details=mysql_fetch_row($ResultAllDetails))
	 {
		 $arrDetails[]=$details;
	 } 
	 mysql_free_result($ResultAllDetails);
	 return $arrDetails;
}


if(isset($detailsinfo))
{

$details=getMoreClassDetails($classID);

title();?>
		<LABEL class=commontitle>School Details Search Info</LABEL>
<?php closetitle();?>
<?php opentable2();?>


	<form action="" method="get" name="form3" id="form3">

    <table width="60%" border="0" align="center" class="myTable">
      <label class="boxtitle" style="position:static "> Class Name: <?php echo $clsname[0]; ?></label>

<?php 
foreach($details as $vals)
?>		   

		   <TR>
		    <td width="50%"><div align="left">Class Id </div></td>
			<td><div align="left"><?php echo $vals[0]; ?></div></td></tr>
			</tr>
			<tr>
			<td width="50%"><div align="left">Class Name </div></td>
		   	<td><div align="left"><?php echo $vals[1]; ?></div></td>
            </tr>   

	  <?php
}  //foreach ends here.
?>       

         </table></form>      <?php closetable(); 
}
?>     

a v vishnu

[dagon]

It's not $vals[0] and $vals[1] it's just $vals

http://nz.php.net/foreach

$clsname is not defined anywhere

[avvishnu]

i used the same code to display another table. In that code i used the $vals[0] . so it works properly. thn about the $clsname is declared before. i didnt copied all those codes. the main problem in this code is the for loop is not working. if it works properly i thnik i ill get the query result from the database. wil u please check it out.

[NogDog]

I'd suggest that for debugging purposes you print out the values of $details just before your foreach loop on it, to make sure it contains the data (if any) you think it should:

printf("<pre>%s</pre>\n", print_r($details, 1));

[avvishnu]

I have a table which can a variable number of rows. each row will have a button.If any of that button in the rows will select , I need to display more details about that particular row , below the existing table.

How can i call the moredetails function from the button.

Now the problem is when i click the submit button the first table and the more details table will come directly.

The main problem is here in the code...

foreach($details as $vals)
{
?>
          <tr>
            <td align="center"><?php echo $vals[0]; ?></td>
            <td align="center"><?php echo $vals[1]; ?></td>
            <td align="center"><input name="detailsinfo" type="submit" id="detailsinfo" value="." onclick="<?php sending($vals[0]);?>"/></td>
            <?php
}

f i use a calling function inside the onclick it ill produce the whole details inside that particular column of the first table.
if i use a isset function it ill not display anything..
how can i display the details table below the first table.

please help me..