SQL Syntax error problem

Python

I have got this code:

[PHP] // Last Poster
$sql = "SELECT `author` FROM ".$DBprefix."posts WHERE `forum` = $forum[id]";
$query3 = $DB->Query($sql);
$rows = $DB->FetchRow($query3);
$lastposterid = $rows[0];
// Find the username
echo $rows[0]."<br>"; // just testing to see if value is there
$sql = "SELECT `username` FROM ".$DBprefix."users WHERE `userid` = $rows[0] LIMIT 1";
$query3 = $DB->Query($sql);
$rows = $DB->FetchRow($query3);
$forumlastposter = $rows[0];[/PHP]

But the problem is that I get this error:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1

I cant figure it out...

Am I doing something wrong?
Thanks

daboss

p, try this:

$sql = "SELECT username FROM ".$DBprefix."users WHERE userid = ".$rows[0]." LIMIT 1";

Python

nope... still comes up with an error.

daboss

p,

print out the actual sql statement and the error...

it's strange that there's an error...