LEFT() funktion does not work

[wxdqz]

Hi,

I have now been trying to get an LEFT funktion in a mysql query to work. When
I use the select function in mysqlmonitor it works fine, but when i put the exactlly function in php the variable ($nnyheter) gets empty (

<?php
$db = mysql_connect("xxx", "xxxx", "xxxx");
mysql_select_db("bredband",$db);

$nyheten = mysql_query("SELECT nyhet, nyid, date, rubrik, link, namn, email " .
"FROM nyheter, authors WHERE authid=authors.idnr and nyid=$id");

while ($nyhet = mysql_fetch_array($nyheten)) {
$idnum = $nyhet["nyid"];
$datum = $nyhet["date"];
$nrubrik = $nyhet["rubrik"];
$nnyhet = $nyhet["nyhet"];
$nlank = $nyhet["link"];
$namn = $nyhet["namn"];
$nemail = $nyhet["email"];

echo "<p align=right>$datum</p><table border=0><tr><td><h2>$nrubrik</h2></td></tr>";
echo "<tr><td colspan=2>$nnyhet</td></tr>";
echo "</table><table><tr><td with=200><b>L鋘k:</b> <A HREF=http://$nlank>$nlank</A>";
echo "</td><td width=200>Av:<A HREF='mailto:$nemail'>$namn</A>";
echo "</tr></td></table><br><br>";

}
?>