$sql = "SELECT LEFT(字段名,限制的標題長度) AS title FROM 表名";
---------------------------------------
css格式化
css
.contents ul{ width:120px;
overflow:hidden;
//line-height:18px;
}
.contents ul li{
overflow:hidden;
}
.contents ul li a{
margin:0;
display:block;
width:100px;
white-space:nowrap;
float:left;
text-overflow:ellipsis;
overflow:hidden;
}
html
<div class="contents">
<ul id="c_jcdj_u">
<li><a href='newsDetail.html?id={0}'>標題,任意長度標題,任意長度標題,任意長度</a></li>
<li><a href='newsDetail.html?id={0}'>標題,任意長度標題,任意長度標題,任意長度</a></li>
<li><a href='newsDetail.html?id={0}'>標題,任意長度標題,任意長度標題,任意長度</a></li>
<li><a href='newsDetail.html?id={0}'>標題,任意長度標題,任意長度標題,任意長度</a></li>
<li><a href='newsDetail.html?id={0}'>標題,任意長度標題,任意長度標題,任意長度</a></li>
</ul>
</div>