here's what i've got:
PHP Code:
<?
require("./global.php");
$uinfo=$DB_site->query_first("SELECT userid, password FROM user WHERE username = '$USER'");
if ($uinfo[password]!=$PASS) exit;
$SONG=addslashes($SONG);
$ARTIST=addslashes($ADDSLASHES);
$ALBUM=addslashes($ALBUM);
$DB_site->query("INSERT INTO nowplaying (nowplayingid, userid, song, artist, album, dateline) VALUES ('0', '".$uinfo[userid]."', '$SONG', '$ARTIST', '$ALBUM', '".time()."')");
?>
it still won't insert, and it seems $ARTIST is not being set from the query string as it should, because i got it to insert once when i used $bbuserinfo rather than my own query and the artist field was blank. however, i need to use my own query.