manage_offers1.php

通达OA部分源代码

<?php
include_once'logincheck.php';
include_once("myconnect.php");
/*
/////////---getting config---------
	$sbq_con='select * from sbbleads_config where sb_id=1';
	$sbrow_con=mysql_fetch_array(mysql_query($sbq_con));
	
	$sbq_gro='select * from sbbleads_groups where sb_memtype='.$_SESSION["sbbleads_memtype"];
	$sbrow_gro=mysql_fetch_array(mysql_query($sbq_gro));
/////////////
*/
function main ()
{
	$sbq_off='select * from sbbleads_offers where sb_uid='.$_SESSION["sbbleads_userid"];
	$sbrs_off=mysql_query($sbq_off);
?>
  <table width="90%" border="0" align="center" cellpadding="2" cellspacing="5" class="onepxtable">
    <tr class="titlestyle"> 
      
    <td width="106%">&nbsp;My Sell Offers</td>
    </tr>
    <tr valign="top"> 
      <td class="innertablestyle"><table width="100%" border="0" cellspacing="0" cellpadding="0">
        <?php 
		 if(mysql_num_rows($sbrs_off) > 0)
		 {	
		 ?>
        <tr> 
          <td><strong>Title</strong></td>
          <td><strong>Images</strong></td>
          <td>&nbsp;</td>
        </tr>
        <?php 	while( $sbrow_off=mysql_fetch_array($sbrs_off) )
		  				{
							$sbq_off_img="select * from sbbleads_offer_images where sb_offer_id=".$sbrow_off['sb_id'];
							$sbno_of_images=mysql_num_rows(mysql_query($sbq_off_img))
						?>
        <tr> 
          <td><a href="edit_offer.php?sb_id=<?php echo $sbrow_off["sb_id"]; ?>"><?php echo $sbrow_off["sb_title"]; ?></a></td>
          <td>(<a href="view_images.php?sb_id=<?php echo $sbrow_off["sb_id"]; ?>" target="_blank"><?php echo $sbno_of_images; ?></a>)</td>
          <td>&nbsp;</td>
        </tr>
        <?php 
			  			}		//end while
		}	//end if num_rows found
		else
		{	?>
        <tr> 
          <td>&nbsp;</td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <?php 
		}	//end else no row found?>
      </table></td>
    </tr>
    <tr valign="top"> 
      <td class="innertablestyle">&nbsp;</td>
    </tr>
  </table>
<?
}
include_once("template1.php");

 ?>