多个条件使用OR

I am having an issue with my SQL code. I need to test multiple conditions against different columns where the inputs are optional. Currently the code will not execute unless both input fields have values. My code is below:

        if((empty($fname) === false or empty($lname) === false) && $date1 == null && $date2 == null)
        {
        $result = mysqli_query($con,"SELECT u.FirstName AS 'First Name', u.LastName AS 'Last Name' , CAST(n.CreatedOn AS date) AS 'Date' , s.SportName AS 'Sport', n.DocumentID AS 'Document ID', n.DocumentName AS 'PDF'
            FROM users u 
            INNER JOIN ncaadocuments n
            ON u.UserID = n.UserID 
            INNER JOIN userathletes a 
            ON n.UserID = a.UserID
            INNER JOIN sport s
            ON a.SportID = s.SportID
            WHERE n.SchoolID = ('$current_user->ID') AND
            (u.FirstName LIKE '%$fname%' OR 
            u.LastName LIKE '%$lname%')
            GROUP BY u.LastName
            ORDER BY n.CreatedOn");
        echo $fname;
        echo $lname;
        show_results($result);

        }
查看全部
dongzongzi0379
dongzongzi0379
2018/04/16 18:43
  • php
  • sql
  • 点赞
  • 收藏
  • 回答
    私信
满意答案
查看全部

1个回复