// Search phone number and get the password
$phone = '947123456789';
$pw = '';
list($pw) = mysql_fetch_array(mysql_query("select pw from table where phone='$phone'"));
if($pw) {
// Search phone numbers
$search_q = mysql_query("select * from table where pw='$pw'");
while ($row = mysql_fetch_array($search_q)) {
// Print Matched Records
print $row['phone'] . "<br />";
}
}
Try this
PHP:// Search phone number and get the password $phone = '947123456789'; $pw = ''; list($pw) = mysql_fetch_array(mysql_query("select pw from table where phone='$phone'")); if($pw) { // Search phone numbers $search_q = mysql_query("select * from table where pw='$pw'"); while ($row = mysql_fetch_array($search_q)) { // Print Matched Records print $row['phone'] . "<br />"; } }
meka weda machn kohomada api search karana number eka output ekata ena eka nawaththanne?
thanks!
$search_q = mysql_query("select * from table where pw='$pw' and phone != '$phone'");