Insert into help

[amonstr]

Im currently working on some code that queries a db and pulls several fields and inserts them into another db. However Im running into an issue where it isnt inputting into a specific field (tracs) but it pulls the rest.

 

$run = mysql_query($query);
while ($row = mysql_fetch_array($run))
{
if($row[TRACS] !=='')
                {
include_once 'db2.php';
$sql="INSERT INTO data (number, market, tracs, status, date)
VALUES
('$row[caller]','$row[market]','$row[TRACS]','active','$tdy')";
 
if (!mysql_query($sql))
  {
  die('Error: ' . mysql_error());
  }
}

Any thoughts? The output is looking something like this.

 

id number market tracs status date Edit Delete

1189327 5555555555 Ft_Bragg active 2013-03-16 15:45:4

Edited March 16, 2013 by ignace
Added code tags

[Failing_Solutions]

Are you sure you are referencing the right databases

http://stackoverflow.com/questions/274892/how-do-you-connect-to-multiple-mysql-databases-on-a-single-webpage