[EMAIL PROTECTED] wrote:
here is the whole query:

$query = "INSERT INTO inmarsat_comp SET date_added=NOW(), prefix='$prefix',
firstname='$firstname', lastname='$lastname', job_title='$jobtitle',
company_name='$company',
no_of_employees='$employees',address_1='$address1',address_2='$address2',
address_3='$address3', town='$town', county ='$county', postcode='$postcode',
country ='$country', telephone_number='$telcode.$telnumber',
fax_number='$faxcode.$faxnumber', email='$email', enterprise='$enterprises',
optin_thirdparty='$distribute', optin_news='$market'";

only the telcode gets inserted.

I guess telephone_number is type INT, then "telephone_number= '$telcode.$telnumber' " becomes "telephone_number= '555.456545' ", which is float, converted to int becomes just 555.


You don't need concatenation oparators (.) within doublequoted strings, use just "telephone_number= '$telcode$telnumber' "

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to