RE: [PHP] how to concatenate php variables in mysql query

2004-09-22 Thread Jay Blanchard
[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

Re: [PHP] how to concatenate php variables in mysql query

2004-09-22 Thread luke
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',

RE: [PHP] how to concatenate php variables in mysql query

2004-09-22 Thread Jay Blanchard
[snip] telephone_number='$telcode.$telnumber', only the telcode gets inserted. [/snip] Concat them before placing into the query...(have you echo'd $telnumber to make sure it is not empty?) $wholeTelNumber = $telcode . $telnumber; echo $wholeTelNumber; telephone_number='$wholeTelNumber', --

Re: [PHP] how to concatenate php variables in mysql query

2004-09-22 Thread Daniel Kullik
[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',

Re: [PHP] how to concatenate php variables in mysql query

2004-09-22 Thread John Holmes
From: [EMAIL PROTECTED] $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',

Re: [PHP] how to concatenate php variables in mysql query

2004-09-22 Thread Daniel Kullik
Daniel Kullik wrote: [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',

Re: [PHP] how to concatenate php variables in mysql query

2004-09-22 Thread Marek Kilimajer
[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',

RE: [PHP] how to concatenate php variables in mysql query

2004-09-22 Thread Yoed Anis
. Yoed -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 7:47 AM To: Jay Blanchard; [EMAIL PROTECTED] Subject: Re: [PHP] how to concatenate php variables in mysql query here is the whole query: $query = INSERT INTO inmarsat_comp