Whats wrong with this?

[Owen]

<?php

////database info removed

mysql_connect($db_host, $db_user, $db_pw)
OR die ("Cannot connect to your database");
mysql_select_db($db_name) OR die("Cannot connect to your database");

$thread_sql = mysql_query("SELECT nowplaying FROM post WHERE visible=1 AND open=1 ORDER BY nowplaying DESC LIMIT 0 , 10);

while($thread_get=mysql_fetch_array($thread_sql))
{
$song = $thread_get[nowplaying];

echo "$thread_get[nowplaying]";
}

?>


I am trying to get the last songs played, so I want to get the latest # entries from the nowplaying entry in the posts table.

[Boofo]

Have you tried echo $song?

[Dean C]

Also do you have any data in the database?

[Owen]

yea, I get a parse error.

[Dean C]

$thread_sql = mysql_query("SELECT nowplaying FROM post WHERE visible=1 AND open=1 ORDER BY nowplaying DESC LIMIT 0 , 10");


You were missing a double-quote :) Btw in future when you get errors it's always helpful to post up the error.... ;)

[Owen]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/vxforums/public_html/song.php on line 14

Now I get this error...