我对select语句还很陌生,所以有人能帮我完成PHP查询吗。
MYSQL表中有5列(Partner_Name、Partner_Name2、Partner_Name 3、Partner_Name4和Partner_Name5)
我当前的PHP语句如下所示。
$query = mysqli_query( $connection, "SELECT * FROM tblclients WHERE tblclients.partner_name = 'Store_1' AND tblclients.package = 'standard' AND tblclients.category = 'all' LIMIT 0, 9");
我的目标是拥有这样的东西。。。
$query = mysqli_query( $connection, "SELECT * FROM tblclients WHERE tblclients.partner_name = 'Store_1' OR tblclients.partner_name_2 = 'Store_1' OR tblclients.partner_name_3 = 'Store_1' OR tblclients.partner_name_4 = 'Store_1' OR tblclients.partner_name_5 = 'Store_1' AND tblclients.package = 'standard' AND tblclients.category = 'all' 0, 9");
它似乎没有像我预期的那样返回结果。我这样做不对吗?
试试这个:
$query = mysqli_query( $connection, "SELECT * FROM tblclients WHERE tblclients.package = 'standard' AND tblclients.category = 'all' AND (tblclients.partner_name = 'Store_1' OR tblclients.partner_name_2 = 'Store_1' OR tblclients.partner_name_3 = 'Store_1' OR tblclients.partner_name_4 = 'Store_1' OR tblclients.partner_name_5 = 'Store_1') 0, 9");
btw,您忘记在第二个查询中添加LIMIT。
$query=mysqli_query($connection,"SELECT*FROM tblclients WHERE tblclients.package=‘standard’AND tblclients.category=‘all’AND(tblclients_partner_name=‘Store_1’OR tblclients.partner_name _2=‘Store_1'OR tblcclients.partner_name _3=‘Store'1'OR tblclients.partner_name _4=‘Store1'OR tblcClients.partner_name=’Store_1')LIMIT 0,9");
如果你有时间,也许可以对表进行优化,这样你的查询就会更好、更容易阅读。
试试这个:
$query=mysqli_query($connection,"SELECT*FROM tblclients WHERE(tblclients.partner_name='Store_1'或tblclients_partner_name_2='Store1'或tblcclients.partner_name_3='Store_1'或tblclients.partner_name_4='Store'1'或tbcclients.partnername_5='Store_2')AND tblclients.cackage='standard'AND tblcclients.category='all'limit 0,9");
在您的情况下,只需使用(…OR…):
AND(tblclients.partner_name='Store_1'或tblclients.cartner_name_2="Store_1"或…)