MySQL won't echo :/

[ChrisMartino]

ok so i have some information in these tables but it wont echo the data this is how i am trying to echo it:

 

// Grabs the current downloads
$NameDownload = "Downloads";
$DownloadQuery = mysql_query("SELECT * FROM site WHERE name = '".$NameDownload."'");
$DownloadFetch = mysql_fetch_array($DownloadQuery);
$Downloads = $DownloadFetch['Contents'];
        echo $Downloads;

 

But it doesn't echo anything?.

[Catfish]

verify your data. print_r($DownloadFetch);

 

if there's nothing there something is failing.

[SpankMarvin]

I think you are producing a multidimensional array here.

 

Try the following. I'm assuming you want a list of the "contents" rows from your results...

 

	

// Grabs the current downloads
$NameDownload = "Downloads";
$DownloadQuery = mysql_query("SELECT * FROM site WHERE name = '".$NameDownload."'");
$DownloadFetch = mysql_fetch_array($DownloadQuery);
echo("<ul>");
foreach($DownloadFetch as $row){
$Downloads = $row['Contents'];
echo("<li>".$Downloads."</li>");
}
echo("</ul>");

 

Any luck?