why won't this thing select?!

[N!ck]

PHP Code:

$nowplaying=$DB_site->fetch_array($DB_site->query_first("SELECT * FROM nowplaying WHERE userid = '".$bbuserinfo[userid]."' ORDER BY dateline DESC LIMIT 1"));
$nptext = "\"".$nowplaying[song]."\"-".$nowplaying[artist]; 


i've got it in global.php just above the part that fetches the header template, but when i put $nptext in the template, it just shows up as ""- rather than "<Song Title>"-<Artist>

any ideas?

[Xenon]

because $DB_site->fetch_array just works with db result arrays, but queryfirst doesn't return such an array.

use this:

PHP Code:

$nowplaying=$DB_site->query_first("SELECT * FROM nowplaying WHERE userid = '".$bbuserinfo[userid]."' ORDER BY dateline DESC LIMIT 1");
$nptext = "\"".$nowplaying[song]."\"-".$nowplaying[artist]; 


[N!ck]

still won't work

[Xenon]

well, the query is correct..
be sure the infos are in the DB

and that you don't use $nptext within a function, or if so make it globalized

[N!ck]

ah! thanks, got it. i wasn't logged in...duh.

[Xenon]

*gg*

fine now