Simple query question ?

[fla5h]

If I wanted to return the thread starters userid what would I use ?


I used

PHP Code:

$firstpostinfo=$DB_site->query_first("SELECT userid FROM post WHERE threadid='$threadid' ORDER BY dateline LIMIT 1"); 


in showthread.php

but it didn't work ?

Is the code wrong, or shouldn't it be in showthread ?

Thanks

Fla5h