商务系统 SQL万能标签使用实例(含调商家LOGO)


=========================================================================

1.调热门关键字

SQL语句

SELECT * FROM `p8_keyword` WHERE `num` !=0 Order by list DESC LIMIT 15

参考风格样式:

<div style="background:url($webdb[www_url]/images/default/i/$i.gif) no-

repeat 0px 2px;height:21px;text-indent:1.3em;"><A HREF="$webdb

[www_url]/do/search.php?type=keyword&keyword=$keywords" target='_blank' 

style="$fontcolor;$fontweight">$keywords</a></div>

=========================================================================

2.调商家LOGO图片

SQL语句

SELECT A.*, A.rid AS id, concat( 'business/ico/', A.picurl ) AS picurl

FROM p8_business_company A 

WHERE A.yz=1     ORDER BY  A.yz DESC, A.posttime  DESC LIMIT 10 

参考风格样式:

<div style="float:left;margin-left:5px;margin-top:4px;"> 

              <p class=img><a 

style="display:block;width:120px;height:120px;border:solid #ccc 2px;" 

HREF="/homepage.php?uid=$uid" target="_blank"><img 

style="width:120px;height:120px;border:1px solid #fff;" src="$picurl" 

border="0"></a></p>              <p class=title style="text-

align:center;"><A HREF="/homepage.php?uid=$uid" title='$full_title' 

target="_blank">$title</A></p>

=========================================================================

3.调人才招聘数据

SQL语句

SELECT * FROM p8_business_hr_jobs WHERE 1 order by posttime DESC LIMIT 10 

参考风格样式:

<div style="line-height:180%;">·<A HREF="/jobsshow.php?id=$rs[jobs_id]" 

target='_blank'  style="$fontcolor;$fontweight">$title</a> (<A 

HREF="">$username</A>)</div>

=========================================================================

4.调求职数据

SQL语句

SELECT * FROM p8_business_hr_resume WHERE 1 order by posttime DESC LIMIT 10 

参考风格样式:

<div style="background:url($webdb[www_url]/images/default/ico-3.gif) no-

repeat 0px 3px;padding-left:10px;height:15px;border-bottom:1px dotted 

#E4E4E4;margin-top:3px;"><A HREF="/resumeshow.php?id=$rs[re_id]

" target="_blank" style="$fontcolor;$fontweight">$title</A></div>

    发表新评论