Luke,
MySQL has a built in CONCAT function. This will concat two strings togther.
In your example it would look like telephone_number = CONCAT('$telcode',
'$telnumber') ...
See the MySQL manual for more info on the concat function. Of course using
this function will force the 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 = "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" <[EMAIL PROTECTED]> 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
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
