Newbie Question $2

From: Date: Tue, 17 Jun 2014 02:58:32 +0000
Subject: Newbie Question $2
Groups: php.db 
Request: Send a blank email to php-db+get-48854@lists.php.net to get a copy of this message
Dear List - I have the following code: The input from the form is a 10 digit string [1234567890] which is converted to phone number format [123-456-7890] $phn = $_POST[phone]; $phn = (string)$phn; $dsh = '-'; $Phn = $phn[0].$phn[1].$phn[2].$dsh.$phn[3].$phn[4].$phn[5].$dsh.$phn[6].$phn[7].$phn[8].$phn[9];
    echo $Phn; // this is folded by Thunderbird.  In the script, it is //all on one line
    mysql_real_escape_string($Phn);
    $sql1 ='select Lname, Fname from Customers where Phone = $Phn ';
    echo $sql1; //this always shows $phn as Phn and not as a numerical //string.
    $result1 = mysqli_query($cxn, $sql1);
TIA Ethan

« previous php.db (#48854) next »