0

I haven't really messed with $wpdb before, but I'm stuck hard on one part. I'm trying to get the values returned in an associative array.

I've tried both of these

$datarow = $wpdb->get_results("SELECT class_name FROM wp_wcs2_class WHERE id=$classnumber");
$datarow = $wpdb->get_results("SELECT class_name FROM wp_wcs2_class WHERE id=$classnumber",ARRAY_A);

but print_r $datarow; just errors out with Parse error: syntax error, unexpected T_VARIABLE

Any idea what's going wrong? I know the data is there because this returns the correct value:

$nameresult = $wpdb->get_var($wpdb->prepare("SELECT class_name FROM wp_wcs2_class WHERE id=$classnumber",ARRAY_A));
1
  • Please echo the query and check for the syntax. Commented Dec 4, 2013 at 10:08

1 Answer 1

1

It has nothing to do with $wpdb. It's PHP parse error.

print_r is a function, so you can't do print_r $datarow; You should use print_r( $datarow ); instead.

1
  • Lol, wow. A half hour, just to find out it's time for bed. Thanks mate! I'll mark it as answer in 7 mins when it lets me Commented Dec 4, 2013 at 9:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.