2. PHPRunner General questions
  3. [SOLVED]  PHPRunner 6 Master Detail question
This topic is locked
[SOLVED]

 PHPRunner 6 Master Detail question

 		9/2/2011 12:27:14 AM
PHPRunner General questions
L
 lordkain2 author

Is there a way to hide details tittle if there are no records to show.


I check "Hide details link if no child records exist" but still showing.


Thanks
C
 		cgphp 9/2/2011

In the "Before display" event of the view page:

$rs = CustomQuery("SELECT COUNT(*) as details_number FROM EstadoMicro_Feria WHERE FICHA=".$values['FICHA']);

$record = db_fetch_array($rs);
if($record['details_number'] == 0)

{

$xt->assign("displayDetailTable_EstadoMicro_Feria",false);

}
L
 		lordkain2 author 9/2/2011



In the "Before display" event of the view page:

$rs = CustomQuery("SELECT COUNT(*) as details_number FROM EstadoMicro_Feria WHERE FICHA=".$values['FICHA']);

$record = db_fetch_array($rs);
if($record['details_number'] == 0)

{

$xt->assign("displayDetailTable_EstadoMicro_Feria",false);

}



I got this error:


In version 5.3, only shows when have records:
C
 		cgphp 9/3/2011
$rs = CustomQuery("SELECT COUNT(*) as details_number FROM EstadoMicro_Feria WHERE FICHA=".$_GET['editid1']);

$record = db_fetch_array($rs);
if($record['details_number'] == 0)

{

$xt->assign("displayDetailTable_EstadoMicro_Feria",false);

}
L
 		lordkain2 author 9/3/2011

Thanks Christian, I change it to:

$rs = CustomQuery("SELECT COUNT(*) as details_number FROM EstadoMicro_Feria WHERE FICHA='".$_GET['editid1']."'");

$record = db_fetch_array($rs);
if($record['details_number'] == 0)

{

$xt->assign("displayDetailTable_EstadoMicro_Feria",false);

}


And works.