Mysql Execute two query

Question

How do I execute the following code in wordpress

Set time_zone = '+07:00';
SELECT current_date

I tried the following but I didn't get any result.

$sql = 'Set time_zone = '+07:00';
        SELECT current_date'; 
$wpdb->get_var($sql);

I run the query in phpmyadmin and its working but why it doesn't work in wordpress?

xdazz · Accepted Answer · 2014-01-03 04:24:54Z

4

You have to execute the query one by one.

$sql = "Set time_zone = '+07:00'";
$wpdb->get_var($sql); 
$sql = "SELECT current_date"; 
$wpdb->get_var($sql);

answered Jan 3, 2014 at 4:24

xdazz

161k38 gold badges255 silver badges278 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1