Re: how to concatenate php variables in mysql query

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. many thanks, luke m "Jay Blanchard" <jay.blanchard@niicommunications.com> wrote: > [snip] > telphone number =$telcode.$telnumber' > > but only the telcode gets written to the database. > [/snip] > > There is not enough here to know for sure (I am betting this is part of > a query), but if your code looks like the above you are missing a single > quote after the =. Now, if you enclose the variables in the single > quotes without other manipulation it will probably not work as expected. > Can we see the whole query? > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >