php - okakda ban meke warada?

[gembaknb]

mchan mokakda ban meke awla?
ekama databasse eke table 2kak check karanna ona bn. but muu check r eka table ekakne.. $uT,$chkT,$checkUT, if eke adaala

eka comment karoth ganata anith table eka wada karanawa.. ee wagema thamai anith tika comment karoth anith table ekenuth

check wenawa bn. But mehema 2kama eka parata thibbama table 2kenma check kranne na ne bn.. mokada ban awla??

                 $us = $_POST['uname'];
                
             
             $uT = "SELECT * FROM student WHERE Username = '{$us}'";
             $uSt = "SELECT * FROM tutor WHERE Username = '{$us}'";
             $chkUSt = mysqli_query($conn, $uSt) or die(mysqli_error()) ;
             $chkUT = mysqli_query($conn, $uT) or die(mysqli_error()) ;
             
             $checkUSt =mysqli_num_rows($chkUSt);
             $checkUT =mysqli_num_rows($chkUT);
 
             if(($checkUSt != 0) AND ($checkUT != 0)){
                 echo "Your Username is not available";
                }

 

[DooA]

$chkT = mysqli_query($conn, $uT) or die(mysqli_error()) ;

$checkUT =mysqli_num_rows($chkUT);

query එක assign කරන්නේ එකකට. num rows බලන්නේ තව එකක

 

[පොඩි බිමා]

Mokadda ena error eka?? Anith eka IF() eka athule uba daagena inne ekama condition eka ne AND ekak daala??

 

[malith86]

                 $us = $_POST['uname'];
                
             
             $uT = "SELECT * FROM student WHERE Username = '{$us}'";
             $uSt = "SELECT * FROM tutor WHERE Username = '{$us}'";
             $chkUSt = mysqli_query($conn, $uSt) or die(mysqli_error()) ;
             $checkUSt =mysqli_num_rows($chkUSt);
             mysqli_free_result($chkUSt);

             $chkT = mysqli_query($conn, $uT) or die(mysqli_error()) ;
             $checkUT =mysqli_num_rows($chkUT);
             mysqli_free_result($chkUT);
 
             if(($checkUSt != 0) AND ($checkUSt != 0)){
                 echo "Your Username is not available";
                }

meka try karala balanna

mekath balanna wada hoda solution ekak ganna puluwan wei
http://php.net/manual/en/mysqli.quickstart.multiple-statement.php

 

[gembaknb]

Sorry mchanla.. Dn thamai hari code ek..

error ekak mukuth enne na bn.. Mata oona.. Table 2kema check karala ewai e username ek nattan allow kr ona.. Nattn oy thyna ek echo wenn ona.. But eeka hariyta wenne na ne bn

 

[Love kolla]

Dannena bn.. Bump thmi

 

[gembaknb]

Anee kiyapnkoo bn