displaying space if no data is returned- help me

thread_PHP

Hi all
I am finding trouble in placing empty space when no data is returned in report page using php

while (!$rec_report->EOF )
											{

											$code=$rec_report->fields[0];
											$lv_sno=$rec_report->fields[1];
											$lv_parameter=$rec_report->fields[2];
											$lv_guage_spec = $rec_report->fields[3];
											$lv_guage_type=$rec_report->fields[4];
											$code_no=$rec_report->fields[5];

											$comp_code=$rec_report->fields[6];
											$lv_sch_frequency = $rec_report->fields[7];

											if($m_post_selection_mode == 2) 
											{ 

												$code_no = $comp_code;
											 } 
											 else 
											 { 

												$lv_sno=$rec_report->fields[1];
												$lv_parameter=$rec_report->fields[2];
												$code=$rec_report->fields[0];

												$lv_guage_spec = $rec_report->fields[3];
												$lv_guage_type=$rec_report->fields[4];
												$code_no=$rec_report->fields[5];
												$lv_sch_frequency = $rec_report->fields[7];
											$code_no = $code_no;

											 }

																			$mysql_frequency = "select * from table";
											$rec_frequency=$conn->execute($mysql_frequency);
											if ( !$rec_frequency )		echo "conn fail";

											if($lv_row_ctr % 2 == 0)
											{
												echo("<tr bgcolor=$lv_row_col1>");
											}
											else
											{
												echo("<tr bgcolor=$lv_row_col2>");
											}

											if($m_post_selection_mode == 1)
											{
												echo '<td  class="runningleft1">'.$lv_parameter.'</td>';
											}


								echo '<td nowrap class="runningleft1">'.$lv_guage_spec.'</td><td  class="runningleft1">'.$lv_guage_type.'</td>';
								?>
								<td  class="runningleft1"><a href="#" onClick="javascript:window.open('details.php?code1=<?php  echo $code;?>&hdn_hidden_dept=<?php echo $m_post_dept_code;?>&facility_id=<?php echo $lv_post_fac_id;?>','mywindow','menubar=1,resizable=1,scrollbars=1');" style='color:red' alt='View Details'><?php echo $code_no; ?></td>  
								<?php

									echo '<td nowrap class="runningleft1">'.$lv_sch_frequency.'</td>';

									while(!$rec_frequency->EOF)
									{
										$lv_mtn_date = $rec_frequency->fields[0];

										?>
										<td width="90px" nowrap class="runningleft1"><a href="#" onClick="javascript:window.open(123.php?s_no=<?php echo $code;?>&hdn_hidden_dept=<?php echo $m_post_dept_code;?>&facility_id=<?php echo $lv_post_fac_id;?>','mywindow','menubar=1,resizable=1,scrollbars=1');" style='color:red' alt='View Details'>
<?php  

    echo func_formatdate($lv_mtn_date);  // in this location printing the date i want to print a space when no data is returned


?></a></td>
											<?php



										$rec_frequency->MoveNext();
									}

										$lv_row_ctr=$lv_row_ctr+1;
										$rec_report->MoveNext();
								}
						}	
					  else {
							echo "<tr><td colspan=15 class='txt' align='center'><b><font color='red'>No data retreived </font></b></td></tr>";
						  }
								?>

help me

thanks in advance

NogDog

Instead of echoing that function, assign the result to a variable. Then do a simple if/else on that variable, or use the ternary operator:

$result = func_formatdate($lv_mtn_date);
echo (!empty($result)) ? $result : "&nbsp;";

thread_PHP

Hi
Thanks for your reply still it is not working

while (!$rec_report->EOF ) 
                                            { 

                                            $code=$rec_report->fields[0]; 
                                            $lv_sno=$rec_report->fields[1]; 
                                            $lv_parameter=$rec_report->fields[2]; 
                                            $lv_guage_spec = $rec_report->fields[3]; 
                                            $lv_guage_type=$rec_report->fields[4]; 
                                            $code_no=$rec_report->fields[5]; 

                                            $comp_code=$rec_report->fields[6]; 
                                            $lv_sch_frequency = $rec_report->fields[7]; 

                                            if($m_post_selection_mode == 2) 
                                            { 

                                                $code_no = $comp_code; 
                                             } 
                                             else 
                                             { 

                                                $lv_sno=$rec_report->fields[1]; 
                                                $lv_parameter=$rec_report->fields[2]; 
                                                $code=$rec_report->fields[0]; 

                                                $lv_guage_spec = $rec_report->fields[3]; 
                                                $lv_guage_type=$rec_report->fields[4]; 
                                                $code_no=$rec_report->fields[5]; 
                                                $lv_sch_frequency = $rec_report->fields[7]; 
                                            $code_no = $code_no; 

                                             } 

                                                                            $mysql_frequency = "select * from table"; 
                                            $rec_frequency=$conn->execute($mysql_frequency); 
                                            if ( !$rec_frequency )        echo "conn fail"; 

                                            if($lv_row_ctr % 2 == 0) 
                                            { 
                                                echo("<tr bgcolor=$lv_row_col1>"); 
                                            } 
                                            else 
                                            { 
                                                echo("<tr bgcolor=$lv_row_col2>"); 
                                            } 

                                            if($m_post_selection_mode == 1) 
                                            { 
                                                echo '<td  class="runningleft1">'.$lv_parameter.'</td>'; 
                                            } 


                                echo '<td nowrap class="runningleft1">'.$lv_guage_spec.'</td><td  class="runningleft1">'.$lv_guage_type.'</td>'; 
                                ?> 
                                <td  class="runningleft1"><a href="#" onClick="javascript:window.open('details.php?code1=<?php echo $code;?>&hdn_hidden_dept=<?php echo $m_post_dept_code;?>&facility_id=<?php echo $lv_post_fac_id;?>','mywindow','menubar=1,resizable=1,scrollbars=1');" style='color:red' alt='View Details'><?php echo $code_no; ?></td>   
                                <?php 

                                    echo '<td nowrap class="runningleft1">'.$lv_sch_frequency.'</td>'; 

                                    while(!$rec_frequency->EOF) 
                                    { 
                                        $lv_mtn_date = $rec_frequency->fields[0]; 

                                        ?> 
                                        <td width="90px" nowrap class="runningleft1"><a href="#" onClick="javascript:window.open(123.php?s_no=<?php echo $code;?>&hdn_hidden_dept=<?php echo $m_post_dept_code;?>&facility_id=<?php echo $lv_post_fac_id;?>','mywindow','menubar=1,resizable=1,scrollbars=1');" style='color:red' alt='View Details'> 
<?php 
    $result = func_formatdate($lv_mtn_date); 
echo (!empty($result)) ? $result : "&nbsp;"; 
 echo func_formatdate($lv_mtn_date);  // in this location printing the date i want to print a space when no data is returned 


?></a></td> 
                                            <?php 



                                        $rec_frequency->MoveNext(); 
                                    } 

                                        $lv_row_ctr=$lv_row_ctr+1; 
                                        $rec_report->MoveNext(); 
                                } 
                        }     
                      else { 
                            echo "<tr><td colspan=15 class='txt' align='center'><b><font color='red'>No data retreived </font></b></td></tr>"; 
                          } 
                                ?> 
help me 

thanks in advance

I replaced this following one with the reply given by you
echo func_formatdate($lv_mtn_date); // in this location printing the date i want to print a space when no data is returned

following one your code
$result = func_formatdate($lv_mtn_date);
echo (!empty($result)) ? $result : " ";

thread_PHP

please help me

thread_PHP

Hi all
In the following query i am using distinct tdate to fetch date field in the query but data is available in $lv_mtn_date i think that's why i am unable to print empty space in that location correct my code if i am wrong

 $result = func_formatdate($lv_mtn_date); 
echo (!empty($result)) ? $result : "&nbsp;";

 $mysql_frequency = "select distinct tdate from table"; 
                              $rec_frequency=$conn->execute($mysql_frequency);

Thanks in advance