Similar to how you can insert into an array using code such as
$wpdb->insert( $table_name, $inputs); //where inputs is an array
I want to do a sql select statement with code such as
$wpdb->get_results("SELECT * FROM " . $table_name . " WHERE " . $input);
where input could contain several search parameters. Is anything like this possible?
Pass your information through prepare as in this example from the Codex:
$metakey = "Harriet's Adages";
$metavalue = "WordPress' database interface is like Sunday Morning: Easy.";
$wpdb->query( $wpdb->prepare(
"
INSERT INTO $wpdb->postmeta
( post_id, meta_key, meta_value )
VALUES ( %d, %s, %s )
",
array(
10,
$metakey,
$metavalue
)
) );
Your array should have the same number of elements as your query string has placeholders.
