Limit antal tegn

er det ikke nemmest bare at lave en:

substr($r['teamname'],0,40);


Den tager $r['teamname'] og starter ved bogstav 0 og tager 40 bogstaver frem.

Det er meget muligt. Har prøvet at erstatte LEFT(te.name, 20)
med substr($r['teamname'],0,40); men det virker ikke. Kan du fortælle mig hvor substring skal indsættes?

$res = mysql_query("SELECT

aa.navn AS navn,
aa.nummer AS nummer,
aa.year AS year,
aa.hold AS hold,
ec.id AS id,
ec.aar AS aar,
ec.placering AS placering,
ec.stage AS stage,
ec.rytter AS rytter,
ec.tid AS tid,
ec.length AS length,
ec.andet AS andet,
et.id AS etapeid,
et.number AS number,
et.afstand AS afstand,
et.types AS types,
t.flags AS flags,
t.id AS rytterid,
t.name AS name,
te.id AS teamid,
te.name AS teamname,
ty.id AS tyid,
ty.team AS team,

LEFT(te.name, 20)

FROM
    alleaar AS aa
    INNER JOIN
    turen AS t
ON
    ec.rytter = t.id
    INNER JOIN
    etapeclass AS ec
ON
    ec.rytter = t.id
    INNER JOIN
    etaper AS et
ON
    ec.stage = et.id

    INNER JOIN
    teams AS te
ON
    aa.hold = te.id

    INNER JOIN
    teamyear AS ty
ON
    ty.team = te.id

WHERE aa.year=$aar AND et.year=$aar AND aa.navn = t.id AND et.id=$id

GROUP BY
    t.id

ORDER BY ec.placering ASC

");



while($r = mysql_fetch_array($res)) {

        echo  "<table width='590' border='0' cellspacing='0' cellpadding='0'><tr><td  style='border-bottom:solid 1px #C2C2A6;'>";
      echo "<table border='0' cellspacing='0' cellpadding='2'><tr>";
        echo "<td width='25' align='right' valign='bottom'>$r[placering].</td>";
        echo "<td width='15' align='center' valign='bottom'><strong><font color='#FF0000'>$r[andet]</font></strong></td>";
        echo "<td width='20' align='left' valign='top'><img src=$r[flags] width='15' height='10' border=0></td>";
        echo "<td width='20' align='right' valign='top'>$r[nummer]</td>";
        echo "<td width='207' align='left' valign='bottom'><a href='http://www.tourfacts.dk/profilryttere.php?id=$r[rytterid]' class='link2' target='_self'>$r[name]</a></td>";
        echo "<td width='233' align='left' valign='bottom'><a href='http://www.tourfacts.dk/year/teamriders.php?aar=$aar&hold=$r[teamid]' class='link2' target='_self'>".substr(0,40,$r[teamname])."</a></td>";
        echo "<td width='60' align='right' valign='bottom'>$r[tid]</td>";
        echo "</tr></table>";
        echo "</td></tr></table>";

}

Det burde virke.. i øvrigt burde du gøre sådan, at når du i en echo bruger en variabel gør du sådan her:


echo '<a href="'.$id.'">';

fremfor:

echo '<a href="$id">';

Tak. Har prøvet at kopiere scriptet ind på min side, men nu kommer der slet ikke noget teamname.

sikkert mig der har lavet en fejl, 2 sek..

Jeps - bytter altid rundt på faktorernes orden i den funktion :P

$res = mysql_query("SELECT

aa.navn AS navn,
aa.nummer AS nummer,
aa.year AS year,
aa.hold AS hold,
ec.id AS id,
ec.aar AS aar,
ec.placering AS placering,
ec.stage AS stage,
ec.rytter AS rytter,
ec.tid AS tid,
ec.length AS length,
ec.andet AS andet,
et.id AS etapeid,
et.number AS number,
et.afstand AS afstand,
et.types AS types,
t.flags AS flags,
t.id AS rytterid,
t.name AS name,
te.id AS teamid,
te.name AS teamname,
ty.id AS tyid,
ty.team AS team,

LEFT(te.name, 20)

FROM
    alleaar AS aa
    INNER JOIN
    turen AS t
ON
    ec.rytter = t.id
    INNER JOIN
    etapeclass AS ec
ON
    ec.rytter = t.id
    INNER JOIN
    etaper AS et
ON
    ec.stage = et.id

    INNER JOIN
    teams AS te
ON
    aa.hold = te.id

    INNER JOIN
    teamyear AS ty
ON
    ty.team = te.id

WHERE aa.year=$aar AND et.year=$aar AND aa.navn = t.id AND et.id=$id

GROUP BY
    t.id

ORDER BY ec.placering ASC

");



while($r = mysql_fetch_array($res)) {

        echo  "<table width='590' border='0' cellspacing='0' cellpadding='0'><tr><td  style='border-bottom:solid 1px #C2C2A6;'>";
      echo "<table border='0' cellspacing='0' cellpadding='2'><tr>";
        echo "<td width='25' align='right' valign='bottom'>$r[placering].</td>";
        echo "<td width='15' align='center' valign='bottom'><strong><font color='#FF0000'>$r[andet]</font></strong></td>";
        echo "<td width='20' align='left' valign='top'><img src=$r[flags] width='15' height='10' border=0></td>";
        echo "<td width='20' align='right' valign='top'>$r[nummer]</td>";
        echo "<td width='207' align='left' valign='bottom'><a href='http://www.tourfacts.dk/profilryttere.php?id=$r[rytterid]' class='link2' target='_self'>$r[name]</a></td>";
        echo "<td width='233' align='left' valign='bottom'><a href='http://www.tourfacts.dk/year/teamriders.php?aar=$aar&hold=$r[teamid]' class='link2' target='_self'>".substr($r['teamname'], 0, 40)."</a></td>";
        echo "<td width='60' align='right' valign='bottom'>$r[tid]</td>";
        echo "</tr></table>";
        echo "</td></tr></table>";

}

I øvrigt vil jeg også råde dig til at skrive tingene med '' omkring.. altså:


$r['teamname']

istedet for:

$r[teamname]

Så sad sen lige i skabet. Lige 2 små spørgsmål mere.
Er det muligt at sætte to prikker efter teamname? Og hvad er fordelen ved at bruge $r['teamname']?
Tusind tak for hjælpen. Du må gerne smide et svar så du kan få det du rettelig har krav på.

$r['teamname'] giver ikke en parse/fatal error i den nye PHP-version.. det gør $r[teamname] hvis du har slået fejlmeddelelserne til i php..

Og ja, det kan du da..

scriptet er nok bare sådan her:

$teamname = $r['teamname'];
if( strlen($teamname) > 40 )
{
$teamname = substr($teamname,0,40).'..';
}


Og det er indsat i din kode her:
-------------------------------


$res = mysql_query("SELECT

aa.navn AS navn,
aa.nummer AS nummer,
aa.year AS year,
aa.hold AS hold,
ec.id AS id,
ec.aar AS aar,
ec.placering AS placering,
ec.stage AS stage,
ec.rytter AS rytter,
ec.tid AS tid,
ec.length AS length,
ec.andet AS andet,
et.id AS etapeid,
et.number AS number,
et.afstand AS afstand,
et.types AS types,
t.flags AS flags,
t.id AS rytterid,
t.name AS name,
te.id AS teamid,
te.name AS teamname,
ty.id AS tyid,
ty.team AS team,

LEFT(te.name, 20)

FROM
    alleaar AS aa
    INNER JOIN
    turen AS t
ON
    ec.rytter = t.id
    INNER JOIN
    etapeclass AS ec
ON
    ec.rytter = t.id
    INNER JOIN
    etaper AS et
ON
    ec.stage = et.id

    INNER JOIN
    teams AS te
ON
    aa.hold = te.id

    INNER JOIN
    teamyear AS ty
ON
    ty.team = te.id

WHERE aa.year=$aar AND et.year=$aar AND aa.navn = t.id AND et.id=$id

GROUP BY
    t.id

ORDER BY ec.placering ASC

");



while($r = mysql_fetch_array($res)) {

$teamname = $r['teamname'];
if( strlen($teamname) > 40 )
{
$teamname = substr($teamname,0,40).'..';
}

        echo  "<table width='590' border='0' cellspacing='0' cellpadding='0'><tr><td  style='border-bottom:solid 1px #C2C2A6;'>";
      echo "<table border='0' cellspacing='0' cellpadding='2'><tr>";
        echo "<td width='25' align='right' valign='bottom'>$r[placering].</td>";
        echo "<td width='15' align='center' valign='bottom'><strong><font color='#FF0000'>$r[andet]</font></strong></td>";
        echo "<td width='20' align='left' valign='top'><img src=$r[flags] width='15' height='10' border=0></td>";
        echo "<td width='20' align='right' valign='top'>$r[nummer]</td>";
        echo "<td width='207' align='left' valign='bottom'><a href='http://www.tourfacts.dk/profilryttere.php?id=$r[rytterid]' class='link2' target='_self'>$r[name]</a></td>";
        echo "<td width='233' align='left' valign='bottom'><a href='http://www.tourfacts.dk/year/teamriders.php?aar=$aar&hold=$r[teamid]' class='link2' target='_self'>" . $teamname . "</a></td>";
        echo "<td width='60' align='right' valign='bottom'>$r[tid]</td>";
        echo "</tr></table>";
        echo "</td></tr></table>";

}

Nej, jeg behøver ikke point :o)
Det er fint for mig, at det virker, hehe.. :P

svar