Creating simple PHP file to call info

[paul41598]

This is kinda in response to this thread here that I made:
https://vborg.vbsupport.ru/showthread.php?t=96420

Since I probably cant get someone to create the addon for me, I minus well try the code myself? How do I create a simple query to call info from the table in the database, with the secret admirer info?

So far I have:

PHP Code:

require_once('./global.php');


    
    $query= $DB_site->query_first("SELECT userid, admiresuserid, datecreated FROM ".TABLE_PREFIX."secretadmirer");
    $num = $DB_site->num_rows($query); 


and it doesnt work