Проблем с променлива $

[bobbykokala]

Здравейте!
Имам проблем,може би е със извеждането на данни от базата. Излиза ми $trackname вместо записа от базата данни.
Поставям кода,който съм направил

<?php	
// id, trackname, preview, download, author, added...
$query = mysql_query("SELECT * FROM `tracks` ORDER BY `id` DESC LIMIT 10");
while ($row = mysql_fetch_array($query)) {
$trackname = $row[trackname];
$preview = $row[preview];
$download = $row[download];
$author = $row[author];
$added = $row[added];

echo '
			<div id="news">
			    <div id="news-title">
					<div class="news-title">$trackname</div>
				</div>
			<div id="news-cont">
			<div class="news-cont">$preview <br> $download <br> $added by $author</div>
			</div>
			<div id="news-bottom"> </div>
			</div>
'; }
?>

От какво се получава това и защо? Преди head-a в php файла имам require на файла за връзка с базата данни connect.php


Извинявам се ако темата е в грешен раздел!

 

[koko92_national]

<?php   
// id, trackname, preview, download, author, added...
$query = mysql_query("SELECT * FROM `tracks` ORDER BY `id` DESC LIMIT 10");
while ($row = mysql_fetch_array($query)) {
$trackname = $row[trackname];
$preview = $row[preview];
$download = $row[download];
$author = $row[author];
$added = $row[added];

echo "
         <div id=\"news\">
             <div id=\"news-title\">
               <div class=\"news-title\">$trackname</div>
            </div>
         <div id=\"news-cont\">
         <div class=\"news-cont\">$preview <br> $download <br> $added by $author</div>
         </div>
         <div id=\"news-bottom\"> </div>
         </div>
"; }
?>

 

[UltimateToTaL]

	<?php   
// id, trackname, preview, download, author, added...
$query = mysql_query("SELECT * FROM `tracks` ORDER BY `id` DESC LIMIT 10");
while ($row = mysql_fetch_array($query)) {
$trackname = $row[trackname];
$preview = $row[preview];
$download = $row[download];
$author = $row[author];
$added = $row[added];

echo '
         <div id="news">
             <div id="news-title">
               <div class="news-title">'.$trackname.'</div>
            </div>
         <div id="news-cont">
         <div class="news-cont">'.$preview.' <br> '.$download.' <br> '.$added.' by '.$author.'</div>
         </div>
         <div id="news-bottom"> </div>
         </div>
'; }
?>