Reply To: Custom phpMyAdmin database with ACF

• James

• August 9, 2016 at 4:09 pm

Hi @xperiap

Could you please var_dump() the $varA variable? Could you please try the following code?

global $wpdb;
$varA = get_field('city');
var_dump($varA);
echo "\n";

$varB = $wpdb->get_var($wpdb->prepare( 
    "
    SELECT number
    FROM database
    WHERE town = %s
    ",
    $varA
));

echo $varB;

Thanks 🙂