Get value of NewPoints for UID

[Static]

How would I get the value of the NewPoints for a specified UID?

Basically,
I need to get the value of a field, in a row, in a table, in a database.

Thanks.

I have no idea how to work MySQL. :/

[Solidus]

SELECT from_columns FROM table WHERE conditions;

You'll have to look in phpMyAdmin to see what the tables are actually called.

[Static]

Can you tell me what exactly to put in these?

SELECT from_columns FROM mybb_users WHERE conditions;

The field /column heading that I want to get is called "newpoints"

I'm assuming conditions = uid. what should I put there?

Thanks for your help.

---

I have this:

$q = mysql_query("SELECT `newpoints` FROM `mybb_users` WHERE `mybb_users`.`uid` =8"); 

It returns:

Resource id #3

What am I doing wrong?

---

I use this function: (after including it, ofc)

newpoints_addpoints(8, 2, 1, 1, false, true);

Then it returns

Warning: require_once(MYBB_ROOTinc/plugins/newpoints/core/hooks.php) [function.require-once]: failed to open stream: No such file or directory in /home/techprim/public_html/inc/plugins/newpoints.php on line 63

Fatal error: require_once() [function.require]: Failed opening required 'MYBB_ROOTinc/plugins/newpoints/core/hooks.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/techprim/public_html/inc/plugins/newpoints.php on line 63

I put it on index too, so it IS in MYBB. don't know why it isn't taking MYBB_ROOT . "inc/plugins/...." as" inc/plugins/..."