On Mon, Jun 16, 2014 at 10:58 PM, Ethan Rosenberg < erosenberg@xxxxxxxxxxxxxxxxxxxx> wrote: > 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 > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > This page should help you: http://www.php.net//manual/en/language.types.string.php understand the difference between single and double quotes.
