I have a database named: accounts
My search queries right now look like:
Code: Select all
if ($search)
{
$order_crit .= " AND (o.order_id LIKE '%{$search}' ";
$order_crit .= "OR acct.acct_first LIKE '%{$search}%' ";
$order_crit .= "OR acct.acct_last LIKE '%{$search}%' ";
$order_crit .= "OR acct.acct_company LIKE '%{$search}%' ";
$order_crit .= "OR acct.acct_email LIKE '{$search}%' ";
$order_crit .= "OR bt.bill_country LIKE '%{$search}%' ";
$order_crit .= "OR bt.bill_zip LIKE '%{$search}%' ";
$order_crit .= "OR bt.bill_city LIKE '%{$search}%' ";
$order_crit .= "OR bt.bill_state LIKE '%{$search}%' ";
$order_crit .= "OR bt.bill_phone LIKE '%{$search}%') ";
}
Code: Select all
$order_crit .= "OR SELECT * WHERE is_wholesale = '1' AND bt.bill_state LIKE '%{$search}%' ";Code: Select all
function get????($????)
{
$return = false;
$sql = "SELECT * FROM accounts WHERE is_wholesale = '1' AND bt.bill_state LIKE '%{$search}%' ";
if ($query = mysql_query($sql))
{
$arrReturn = array();
while ($row = mysql_fetch_object($query))
{
$arrReturn[] = $row;
}
if (!empty($arrReturn))
{
$return = $arrReturn;
}
}
return($return);
}