getting substr to work

[brockie99]

i posted a thread earlier to shorten text, and got a reply of using substr. now i need to know how to postion the code around the 'print' quotes, as i am getting a parse error. here the line of code:

$select = mysql_query("SELECT * FROM news WHERE newsID = 2;",$db);
while ($myrow = mysql_fetch_array($select))
{
printf ("<tr><td><p class='bold'>%s - %s</p></td></tr><tr><td><p>"$snippet = substr('%s',0,40); echo $snippit;"</p></td></tr>", $myrow["description"], $myrow["date"], $myrow["fullnews"]);
}

could do with some help
thanks

[lilleman]

Try this instead:

$select = mysql_query("SELECT * FROM news WHERE newsID = 2;",$db);
while ($myrow = mysql_fetch_array($select))
{
  $snippet = substr($myrow['fullnews'], 0, 40);
  printf ("<tr><td><p class='bold'>%s - %s</p></td></tr><tr><td><p>%s</p></td></tr>", $myrow["description"], $myrow["date"], $snippet);
}

Yours, Erik.