how to add one more criteria to this?
Posted: Thu Mar 17, 2011 2:02 pm
Code: Select all
$query = "SELECT * FROM wp_network_members WHERE ". implode(' AND ', $searchSql);
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
$query = "SELECT * FROM wp_network_members WHERE ". implode(' AND ', $searchSql);
Code: Select all
$query = "SELECT * FROM wp_network_members WHERE something = '".$yourVar."' AND wp_posts = 'published'";
Code: Select all
Array
(
[0] => 1=1
[1] => `l_name` LIKE '%Brooks%'
)
Code: Select all
$res = mysql_query("SELECT * wp_network_members
WHERE column1 LIKE '%name%' AND column2 LIKE '%anothername%' AND column3 LIKE '%anothername%' AND wp_posts = 'published'");
Code: Select all
$type = 1;
$cond = array();
$cond[] = "column1 LIKE '%name1%'";
$cond[] = "column2 LIKE '%name2%'";
$cond[] = "column3 LIKE '%name3%'";
if(1 == $type)
{
$cond[] = "wp_posts = 'published'";
}
$condition = !empty($cond) ? "where ".implode(" and ", $cond) : '';
$sql = "SELECT * wp_network_members {$condition}";
$res = mysql_query($sql);