Location: PHPKode > projects > Esvon Personals > esvon-personals/inc/blocks/Ad_Details/block-Ads_by_User.php
<?php

// --------------------------------------------------------------------------
//
// Esvon Classifieds v.4.0
// Copyright(C), Esvon LTD, 2001-2010, All Rights Reserved.
// E-mail: hide@address.com
//
// All forms of reproduction, including, but not limited to, internet posting, 
// printing, e-mailing, faxing and recording are strictly prohibited.
// One license required per site running Esvon Classifieds. 
// To obtain a license for using Esvon Classifieds, please register at
// http://www.esvon.com/pg/products/p_classifieds/
//
// --------------------------------------------------------------------------

function block_Ad_Details_Ads_by_User(&$tpl){
  
  global $db,$a_Ad,$TITLE_FIELD;
    
  $ql = 'SELECT link_id AS o_id,'.$TITLE_FIELD.' AS o_title FROM '.TBL_AD.
  	  ' WHERE userid="'.$a_Ad['userid'].'" AND link_id<>"'.$a_Ad['link_id'].'"'.
      hwFilterGetSQL().' ORDER BY '.$TITLE_FIELD;

  $res = $db->query($ql);
  while($v = mysql_fetch_assoc($res)){ 
    $v['o_ad_url'] = hwGetAdURL($v['o_id']);
    $tpl->AddCell('b_Ads_by_User',$v);
  }

}

?>
Return current item: Esvon Personals