PHP - Moved: Insert Select

Hi,

I would like to do the following in PHP using a MySQL database, but not sure how.

select a, b,c etc.. from mailbox where id = X
then
insert id,a,b,c etc.. into problem

When I select, I will be calling the id

So I would like it to get data from mailbox and then insert it into problem.
How would I go about doing this?

Thanks for any help you can give me

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?

Code: [Select]
<?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='someemail@gmail.com' ") or die(mysql_error());

?>

Hi,   I'm really at a loss here.   I have queried a table to get an option list, which returns what I expect but I need to then add it to some current code instead of the fixed option list presented. The syntax is beyond me.     Please see attached. Any pointers would be great.         Attached Files  OptionList.txt   1.61KB   7 downloads

I have tried several attempts and can get data to select and using echo display it, however, I need to take this data and insert it into the database in a separate table.   I have the following which does hafl the job, can I get some pointers on the rest.  I have looked everywhere and not found a solution, at all.


// Selects the data I need
<?php
mysql_connect("PRIVATE INFO","PRIVATE INFO","PRIVATE INFO") or
    die("Could not connect: " . mysql_error());

mysql_select_db("wpdb");

$result = mysql_query("SELECT ID FROM wp_posts

WHERE post_title LIKE '%future%'
AND post_status = 'publish'
OR post_title LIKE '%option%'
AND post_content LIKE '%fundamental%'
AND post_status = 'publish'

   ORDER BY post_date DESC");

while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{   echo $row['ID'];
   echo "<br />";};

?>



Thought maybe something like the following would work, but am at a loss:
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id, term_order)
       SELECT ID FROM wp_posts

            WHERE post_title LIKE '%future%'
            AND post_status = 'publish'
            OR post_title LIKE '%option%'
            AND post_content LIKE '%fundamental%'
            AND post_status = 'publish'

            ORDER BY post_date DESC

            while ($row = mysql_fetch_array($result, MYSQL_ASSOC))

VALUES
($row['ID'], '25', '0')

Well, I made this yesterday then realised, I need to check is it exists...
I got this but when I go to accept the application and the member exists in the table it enters it anyway...

Code: [Select]
<?php
$member=$_POST['memberid'];
$status=$_POST['Status'];

$con = mysql_connect("host","user","pass");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("a2186214_hbclan",$con);
$sql="UPDATE application SET Status = '$status' WHERE ID = '$member'";
$sql1="INSERT INTO table_members(name) SELECT application.Name FROM application WHERE application.ID = '$member'";
if ($status == 'ACCEPTED')
{
if(mysql_num_rows(mysql_query("SELECT name FROM table_members WHERE name = '$member'")))
{
if(mysql_query($sql, $con) or die(mysql_error()))
{
echo 'Status Changed.<br /><a href="../applications.php">Return To Members List</a>';
}
else
{
die('Could not submit: ' . mysql_error());
}
}
else
{
if(mysql_query($sql, $con) or die(mysql_error()))
{
if(mysql_query($sql1, $con) or die(mysql_error()))
{
echo 'Status Changed.<br /><a href="../applications.php">Return To Members List</a>';
}
}
else
{
die('Could not submit: ' . mysql_error());
}
}
}
else
{
if(mysql_query($sql, $con) or die(mysql_error()))
{
echo 'Status Changed.<br /><a href="../applications.php">Return To Members List</a>';
}
else
{
die('Could not submit: ' . mysql_error());
}
}
mysql_close($con);

?>