"; if(preg_match('/^[0-9]{10}+$/', $phone)) { echo "pass Phone Number"; } else { echo "fail Phone Number"; } */ mysql_select_db($database_BE2, $BE2); $query_Rt2 = "SELECT * FROM member WHERE 1 ORDER BY mem_auto"; $Rt2 = mysql_query($query_Rt2, $BE2) or die(mysql_error()); $row_Rt2 = mysql_fetch_assoc($Rt2); $totalRows_Rt2 = mysql_num_rows($Rt2); do { $ck='N'; if(preg_match('/^[0-9]{10}+$/', $row_Rt2['mem_mobile'] )) { $ck='Y';} echo $row_Rt2['mem_auto'].','.$row_Rt2['mem_name'].','.$row_Rt2['scode'].','.$row_Rt2['mem_mobile'].':'.$ck."
"; mysql_select_db($database_BE2, $BE2); $update = sprintf("UPDATE member Set scode_logo= '%s' WHERE mem_auto='%s'",$ck,$row_Rt2['mem_auto']); mysql_query( $update , $BE2) or die(mysql_error()); } while ($row_Rt2 = mysql_fetch_assoc($Rt2)); mysql_free_result($Rt2); ?>