$wpdb table name

Question

I'm having problem with getting data from database via $wpdb:

function nadji_sve_statuse() {  global $wpdb, $leaguemanager;  $league = $leaguemanager->getCurrentLeague();  $svi_statusi = $wpdb->get_var( "SELECT * FROM {$wpdb->leaguemanager_person_status} WHERE 1" );    return $svi_statusi; }

When I replace {$wpdb->leaguemanager_person_status} with full and real table name wp_leaguemanager_person_status, it works fine - but when user tries to rename database table prefixes to something other, a new problem will surface. What am I doing wrong?

Please see here: codex.wordpress.org/…

hakre
– hakre

2012-09-24 13:31:29 +00:00
Commented Sep 24, 2012 at 13:31 — hakre
– hakre, Commented Sep 24, 2012 at 13:31

Zvonko Biskup · Accepted Answer · 2012-09-24 14:25:00Z

You should get the prefix of the table, try this:

function nadji_sve_statuse() { global $wpdb, $leaguemanager; $league = $leaguemanager->getCurrentLeague(); $tableName = $wpdb->prefix . 'leaguemanager_person_status'; $svi_statusi = $wpdb->get_var( "SELECT * FROM {$tableName} WHERE 1" ); return $svi_statusi; }

I recommend you to use backtics surrounding table name "SELECT * FROM `{$tableName}` WHERE 1"

Collectives™ on Stack Overflow

$wpdb table name

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related