<? while($row=mysql_fetch_array($result_prj)) { ?> <tr <? if ($sno%2==1) { ?> bgcolor="#F5F2F1" <? } ?> class="text_1"> <td align="center"><?php echo getDispatchNumber("DispatchNumber", "rec_id", $row['DispatchNumberId']); ?> </td> <td align="center"><?php echo getDateFormate(getDispatchNumber("DespatchDate", "rec_id", $row['DispatchNumberId']), 1); ?> </td> <td align="center"><?php echo getBuyer('BuyerName', 'rec_id', getDispatchNumber("BuyerId", "rec_id", $row['DispatchNumberId'])); ?> </td> <td align="center"><?php echo $row['Port']; ?> </td> <td align="center"><?php echo getCountry(getBuyer('CountryId', 'rec_id', $row['BuyerId'])); ?> </td> <td align="center"><?php echo getProduct("ProductName", "rec_id", $row['ProductId']); ?> </td> <td align="center"><?php
if(mysql_num_rows($result_dn)>0) { $sno = 1; while($row_dn = mysql_fetch_array($result_dn)) { $sql_1 = "select dm.rec_id , dm.PiId , dm.DispatchNumberId from mo_adm_dispatch_master as dm where dm.DispatchNumberId = '".$row_dn["rec_id"]."'"; $result_1 = mysql_query($sql_1)or die("Error in Query: ".$sql_1."<br/>".mysql_error()."<br/>".mysql_errno()); if(mysql_num_rows($result_1)>0) { $row_1 = mysql_fetch_array($result_1); ?> <tr> <td align="center"><?=getPINumber('PiNumber','rec_id',$row_1['PiId'])?></td> <td align="center"><?=$row_dn['DispatchNumber']?></td> <td align="center" class="text_1"><?=getBuyer('BuyerName','rec_id',getDispatchNumber('BuyerId','rec_id',$row_1['DispatchNumberId']))?></td> </tr> <? } ?> <tr> <td align="center" colspan="4"> <table align="center" width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <? $sql = "select ddl.rec_id , ddl.DispatchMasterId , ddl.DocId , ddl.DocStatus , ddl.DocDate , dm.rec_id , dm.PiId , dm.DispatchNumberId from mo_adm_despatch_doclist as ddl , mo_adm_dispatch_master as dm where ddl.DocStatus = '0' and ddl.DispatchMasterId = dm.rec_id and dm.DispatchNumberId = '".$row_dn["rec_id"]."'"; $result = mysql_query($sql)or die("Error in Query: ".$sql."<br/>".mysql_error()."<br/>".mysql_errno()); if(mysql_num_rows($result)>0) { while($row = mysql_fetch_array($result)) //$row = mysql_fetch_array($result);
<?php while ($row = mysql_fetch_array($result_prj)) { ?> <tr <?php if ($sno % 2 == 1) { ?> bgcolor="#F5F2F1" <?php } ?> class="text_1"> <td align="center"><?php echo $sno; ?> </td> <td align="center"><?php echo getDispatchNumber('DispatchNumber', 'rec_id', $row['DispatchNumberId']); ?> </td> <td align="center"><?php echo getPINumber('PiNumber', 'rec_id', $row['PiId']); ?> </td> <td align="center"><?php echo getProduct('ProductName', 'rec_id', $row['ProductId']); ?> </td> <td align="center"><?php echo getCount('Count', 'rec_id', $row['CountId']); ?> </td> <td align="center"><?php
?> </td> </tr> <?php $s++; } ?> </table> </td> </tr> </table> </div> </td> <td align="center"><span class="text_1"><?php echo getBuyer('BuyerName', 'rec_id', getDispatchNumber('BuyerId', 'rec_id', $row_1['DispatchNumberId'])); ?> </span></td> </tr> <?php } ?> <tr> <td align="center" colspan="4"> <table align="center" width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <?php $sql = "select ddl.rec_id , ddl.DispatchMasterId , ddl.DocId , ddl.DocStatus , ddl.DocDate , dm.rec_id , dm.PiId , dm.DispatchNumberId from mo_adm_despatch_doclist as ddl , mo_adm_dispatch_master as dm where ddl.DocStatus = '0' and ddl.DispatchMasterId = dm.rec_id and dm.DispatchNumberId = '" . $row_dn["rec_id"] . "'"; $result = mysql_query($sql) or die("Error in Query: " . $sql . "<br/>" . mysql_error() . "<br/>" . mysql_errno()); if (mysql_num_rows($result) > 0) { while ($row = mysql_fetch_array($result)) {