Problem with $wpdb | ww.wp.xz.cn

kuyss42
(@kuyss42)

11 years, 2 months ago
Hi,

Can i use the SQL Queries in [insert_php]?
```
global $wpdb;

$resultats = $wpdb->get_results( 'SELECT nom FROM $wpdb->boutique_france' ) ;

var_dump($resultats);
```
This query works perfectly on phpMyAdmin.

But this code displays me a blank page…

Thanks a lot!

R.

https://ww.wp.xz.cn/plugins/insert-php/

Viewing 2 replies - 1 through 2 (of 2 total)

Thread Starter kuyss42
(@kuyss42)

11 years, 2 months ago
Mistake
```
global $wpdb;

$resultats = $wpdb->get_results( "SELECT nom FROM $wpdb->boutique_france" ) ;

var_dump($resultats);
```
With ” of course. But it’s always doesn’t works.
WillBontrager
(@willbontrager)

11 years, 2 months ago

Hi kuyss42,

The code must be complete in and of itself. As it is now, $wpdb has no meaning. For $wpdb to have meaning, it must be assigned a value somewhere within the [insert_php]…[/insert_php] section.

See http://www.willmaster.com/software/WPplugins/insert-php-wordpress-plugin-instructions.php#inandofitself for more information. You’ll also be interested in other sections of the instructions page.

Will

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Problem with $wpdb’ is closed to new replies.

2 replies
2 participants
Last reply from: WillBontrager
Last activity: 11 years, 2 months ago
Status: not resolved