data to be a string.
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 = "
[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',
addre
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',
no_of_employees='$employees',address_1='$address1',addres
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', town=
[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',
addre
[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',
--
PH
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='
[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 vari
hi,
i'm trying to concatenate two php variables (containing form data) in a mysql
query. i'm currenty using the dot operator:
telphone number =$telcode.$telnumber'
but only the telcode gets written to the database.
any ideas?
many thanks,
luke m.
--
PHP General Mailing List (http://www.php
9 matches
Mail list logo
