[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
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',
[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',
--
[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',
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',
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',
[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',
.
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
8 matches
Mail list logo