mysql OR查询输出

Question

$sql = "SELECT * FROM dealer_reg_data WHERE dealercode = '$myvalue' OR sender = '$sender'";

if dealercode is found i want to echo message - onlydealer

if sender id found i want to show message - only mobile

if both founf i want to show message - both found

pls help how to do that, i have tried this, but it will not work for me

if($sender !== '' || $dealercode !== '' );{
        $reply_message = "both found";
            }
            if($sender !== '');
            {
        $reply_message = "only mobile";
            }
            if($dealercode !== '' );
            {
        $reply_message = "only dealer";
            }

Answer 1

You have an errant semi-colon and || should be &&

if($sender !== '' || $dealercode !== '' ); <-- HERE
                 ^^^^
                 HERE

so it should be:

if($sender !== '' && $dealercode !== '' ) {

|| means or so only one condition needs to be true. You want && which means and and requires both conditions to be true.