how do I copy value from one table and inserted to another in the same database??

Posted by mathew on Stack Overflow See other posts from Stack Overflow or by mathew
Published on 2010-05-16T12:21:53Z Indexed on 2010/05/16 12:30 UTC
Read the original article Hit count: 156

Filed under:
|

I am having a tough time to do this...

I have created two table say table-1 and table-2 in same database.what I want is I need to copy some values from table-1 and insert the same to table-2. I have tried many ways but it does not seems work. below is my code can any one tell me where I am missing??

 $db = mysql_connect("localhost", "user", "pass") or die("Could not connect.");
    mysql_select_db("comdata",$db)or die(mysql_error()); 
    $resultb = mysql_query("SELECT * FROM table-2")or die(mysql_error()); 
    $row = mysql_fetch_array($resultb);
    $days = (strtotime(date("Y-m-d")) - strtotime($row['regtime'])) / (60 * 60 * 24);
    if($row > 0 && $days < 1){
       $person = $row['person'];
       $catogr = $row['catog'];
       $position = $row['position'];
       $location = $row['location'];
       $rank = $row['rank'];
    mysql_close($db);
    }else{
    $db = mysql_connect("localhost", "user", "pass") or die("Could not connect.");
    mysql_select_db("comdata",$db)or die(mysql_error());  
    $result = mysql_query("SELECT * FROM table-1 WHERE regtime = DATE(NOW()) ORDER BY rank ASC LIMIT 1;")or die(mysql_error());
    $row = mysql_fetch_array($result);
       $person = $row['person'];
       $catogr = $row['catog'];
       $position = $row['position'];
       $location = $row['location'];
       $rank = $row['rank'];
 mysql_query("INSERT INTO table-2 
    (regtime,person,catog,position,location,rank)  VALUES(NOW(),'$person','$catogr','$position','$location','$rank')");
    mysql_close($db);
        }

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql