I have created some custom tables within the WP database, and I'm referencing a table called 'projects' in this instance with this query.

'pr_no' is the Project Number

get_var("SELECT pr_no FROM $wpdb->projects WHERE ID=$current_user->ID");
echo "{$projectref}";

However, it echos nothing, and comes up blank. Where have I gone wrong?

At first I thought it was because I'd created my own table within WP, but apparently that's allowed. So I'm stuck!