请教:当supermanager == '2' 的时候,我要求只输出industry=1 or industry=7 的内容
否则当supermanager不等2的时候就输出全部数据
我是个php的菜鸟,望大侠伸手帮助一下,感激不尽!
<?php
session_start();
require_once '../session.php';
require_once '../inc/const.php';
$page = $_GET ['page'] ? $_GET ['page'] : 1;
$page_size = 30;
//if($supermanager == '2')
//{
//$where = " and (industry=1 or industry=7)";
//}
//$sql = "select * from 表名 where 1".$where;
//else
$sqlstr=get_sql("select * from {pre}customer order by rank asc,id desc");//此行语句输出全部数据
$s_list = $db->selectLimit ( $sqlstr, $page_size, ($page - 1) * $page_size );
$total_nums = $db->getRowsNum ( $sqlstr );
?>
否则当supermanager不等2的时候就输出全部数据
我是个php的菜鸟,望大侠伸手帮助一下,感激不尽!
<?php
session_start();
require_once '../session.php';
require_once '../inc/const.php';
$page = $_GET ['page'] ? $_GET ['page'] : 1;
$page_size = 30;
//if($supermanager == '2')
//{
//$where = " and (industry=1 or industry=7)";
//}
//$sql = "select * from 表名 where 1".$where;
//else
$sqlstr=get_sql("select * from {pre}customer order by rank asc,id desc");//此行语句输出全部数据
$s_list = $db->selectLimit ( $sqlstr, $page_size, ($page - 1) * $page_size );
$total_nums = $db->getRowsNum ( $sqlstr );
?>
请问是不是下面这样就可以啊
$sqlstr=get_sql("select * from {pre}customer where (supermanager='2' and (industry=1 or industry=7)) or supermanager!=2 order by rank asc,id desc");//
<?php
session_start();
require_once '../session.php';
require_once '../inc/const.php';
$page = $_GET ['page'] ? $_GET ['page'] : 1;
$page_size = 30;
$sqlstr=get_sql("select * from {pre}customer where (supermanager='2' and (industry=1 or industry=7)) or supermanager!=2 order by rank asc,id desc");//此行语句输出全部数据
$s_list = $db->selectLimit ( $sqlstr, $page_size, ($page - 1) * $page_size );
$total_nums = $db->getRowsNum ( $sqlstr );
?>
你的表有名为 supermanager 的字段吗?
customer和manager 表select a.customer,b.manager from a.customer where a.name='name' and b.(supermanager='2' and (industry=1 or industry=7)) or supermanager!=2 order by rank asc,id desc");要如何才能合起来加入这个条件啊
表名 别名b.supermanager 指
别名.字段名
我想达到 当supermanager='2'的时候 就输出industry=1 和 industry=7 的数据
当supermanager不等于2的时候 就输出全部的数据
b.supermanager='2' and a.industry='1' or a.industry='7'on后面的是两个表的关系字段... 外键.
if($supermanager == '2')
{
$where .= " and (industry=1 or industry=7)";
}
$sqlstr=get_sql("select * from {pre}customer where $where order by rank asc,id desc");//此行语句输出全部数据