Why i can't tranfer data from one table to another with this code? I
can't
pass $reg to $c and $t... : \
thanks
?
$ligacao=mysql_connect(localhost,,) or die (mysql_error());
$real=INSERT INTO divx (titulo,cds) VALUES ('$t','$c');
move the above line...
$temp=SELECT * FROM divxtemp;
//$num=mysql_affected_rows();
$restemp=mysql_db_query(DB_nac31915,$temp) or die (mysql_error());
if ($ligacao)
{
while($reg=mysql_fetch_array($restemp))
{
$t=$reg[titulo];
$c=$reg[cds];
to here...
mysql_db_query(DB_nac31915,$real) or die (mysql_error());
}
}
mysql_close();
?
The problem you're having is that $t and $c are evaluated when you
assign that string to $real, NOT when it's used in mysql_db_query().
Since they are empty at that time, you're creating a SQL statement
that's ... VALUES ('','') and executing it every time.
Also, the mysql_db_query() function is depreciated. You'll have to use
mysql_select_db() to select the database you want to use, then use
mysql_query() to issue your queries.
---John Holmes...
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php