PHP Help ekak one- search mysql table with 2 fields

[praveendpa]

Mata loku udawwak one. danna kenek innawanao help ekak denna. mysql wala student table eke username, password dala tiyenawa. mama variable ekakata assign karagena tiyena $uname value ekai, $pw valui ekai, table eke search karanna one.(field 2kema search wenna ona)

single field ekak nao search karala ganna dannawa.field 2k search karanne kohomada?

(single weda meka)
if($result=$db->query("SELECT firstname,username,password FROM student WHERE username='$nm' "))


field 2kakata puluwanda?

if($result=$db->query("SELECT firstname,username,password FROM student WHERE username='$nm' && password='$pw' "))

wena mona hari widiyak tiyenawada?

Thank you

 

[vdilshan]

SELECT firstname,username,password FROM student WHERE username='$nm' AND password = '$pswd'

$result = $db->query("SELECT firstname,username,password FROM student WHERE username = '".$nm."' AND password = '".$pswd."'")

 

[kolavari]

use AND