да показва не повече от 30 букви?

[aquafresh]

 <?PHP
$sqlquery = "SELECT * from songs order by id desc limit 10";
$queryresult = @mysql_query($sqlquery);
while ($row = @mysql_fetch_array($queryresult))
{
extract($row);
echo"<img src='../images/icons/music.png' />  <a href=\"playsong.php?id=$row[id]\">$row[artist] - $row[title]</a><br>";
}
?>

как ще стане да изкарва не повече от 30 букви?

 

[vik96]

<?PHP
$sqlquery = "SELECT * from songs order by id desc limit 10";
$queryresult = @mysql_query($sqlquery);
while ($row = @mysql_fetch_array($queryresult))
{
extract($row);
$zaglavie=substr($row[artist],0 , 30);
echo"<img src='../images/icons/music.png' /> <a href=\"playsong.php?id=$row[id]\">$zaglavie - $row[title]</a><br>";
}
?>

 

[alex95_bg_2]

 <?PHP
$sqlquery = "SELECT * from songs order by id desc limit 10";
$queryresult = @mysql_query($sqlquery);
while ($row = @mysql_fetch_array($queryresult))
{
$tochki = ($row[title] > 30) ? "..." : "";
$zaglavie=substr($row[title],0 , 30);
echo"<img src='../images/icons/music.png' /> <a href=\"playsong.php?id=$row[id]\">$row[artist] - $zaglavie$tochki</a><br>";
}
?>

според мен искаше на заглавието а не на изпълнителя
и ще слага ... ако е по-дълго

п.с. extract-a видях че не го ползваш и го махнах

 

[emagi]

КОй забрави да преброи символите?

<?PHP
$sqlquery = "SELECT * from songs order by id desc limit 10";
$queryresult = @mysql_query($sqlquery);
while ($row = @mysql_fetch_array($queryresult))
{
$tochki = (strlen($row[title]) > 30) ? "..." : "";
$zaglavie=substr($row[title],0 , 30);
echo"<img src='../images/icons/music.png' /> <a href=\"playsong.php?id=$row[id]\">$row[artist] - $zaglavie$tochki</a><br>";
}
?>

 

[vik96]

КОй забрави да преброи символите?

<?PHP
$sqlquery = "SELECT * from songs order by id desc limit 10";
$queryresult = @mysql_query($sqlquery);
while ($row = @mysql_fetch_array($queryresult))
{
$tochki = (strlen($row[title]) > 30) ? "..." : "";
$zaglavie=substr($row[title],0 , 30);
echo"<img src='../images/icons/music.png' /> <a href="playsong.php?id=$row[id]">$row[artist] - $zaglavie$tochki</a><br>";
}
?>

Кой забрави скобите на STRLEN ?

 

[DeathGuard_]

Така работи 100%

<?PHP
$sqlquery = "SELECT * from songs order by id desc limit 10";
$queryresult = @mysql_query($sqlquery);
function cutes($post_text, $simvola_text) {
if (strlen($post_text)>$simvola_text)
       {$totchkit='...';}
           else
        {$totchkit='';}
         return substr($post_text,0 , $simvola_text).$totchkit;
}
while ($row = @mysql_fetch_array($queryresult))
{
extract($row);
echo"<img src='../images/icons/music.png' />  <a href=\"playsong.php?id=$row[id]\">".cutes($row[artist]." - ".$row[title], 30)."</a><br>";
}
?>