wordpress $wpdb sql querying

Question

I'm working on a WordPress plugin, and I need some help in this.. in this situation, i have already created a table called "wp_pfot", and a row called "title" in that table. I want to be able to check if a value in "title" doesn't exists, and if it doesn't exist, then perform an action. I've already tried this but it doesn't seem to be working.

global $wpdb
$table_name = $wpdb->prefix . "pfot";
$title = "some text";

if(!$wpdb->get_row("SELECT title FROM $table_name WHERE title = '" . $title . "'", 'ARRAY_A')) {
//do something
}

any help would be much appreciated!! thanks...

Robin Manoli · Accepted Answer · 2012-08-17 20:19:54Z

1

ARRAY_A is a constant, not a string.

global $wpdb
$table_name = $wpdb->prefix . "pfot";
$title = "some text";

if($wpdb->get_row("SELECT title FROM $table_name WHERE title = '$title'", ARRAY_A)) {
//do something
}

edited Aug 17, 2012 at 20:19

answered Aug 17, 2012 at 20:14

Robin Manoli

2,2222 gold badges27 silver badges31 bronze badges

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

Collectives™ on Stack Overflow

wordpress $wpdb sql querying

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related