INSERT-INTO-SELECT with concatenated variables

[adriscoll]

Hello.

 

I have  a simple enough code that takes information from one table and drops it into another.  This is great, but I have 2a new complexities that I have been unable to code correctly.

 

A.  'lastname', 'firstname' on table1 need to be combined into 'name'

 

How & Where do I combine these strings and then pass them?

 

<?php
include('dbconfig.php');


// Make a MySQL Connection
mysql_connect("localhost", "$user", "$password") or die(mysql_error());
mysql_select_db("$database") or die(mysql_error());

$result = mysql_query(
"INSERT INTO table2 (lastname, firstname, email)
SELECT lastname, firstname, email
FROM table1
WHERE email='[email protected]' ") or die(mysql_error());

?>

[Nodral]

Hi

 

Do it as 2 seperate queries.

 

$sql="SELECT lastname, firstname, email FROM table1 WHERE email='[email protected]' ";
$sql=mysql_query($sql) or die();
while($row=mysql_fetch_array($sql){
$name=$row['lastname'] . $row['firstname'];
}

$sql="INSERT INTO table2 " .  $name;
mysql_query($sql) or die();

 

 

 

 

 

[adriscoll]

Nodral,

 

I appreciate the response but that query didn't populate anything.  I think it is on the right track, but am unable to execute it.

 

 

[PFMaBiSmAd]

Should work (you provided no information about how the names should be combined) -

 

"INSERT INTO table2 (name, email)
SELECT CONCAT(lastname, firstname), email
FROM table1
WHERE email='[email protected]'"

[adriscoll]

PFMaBiSmAd,

 

Thank you. That worked wonderfully.