damn it... i want to tranfer data from one table to another!
| From: | Mr. BuNgL3 | Date: | Sun, 17 Nov 2002 22:49:31 +0000 |
| Subject: | damn it... i want to tranfer data from one table to another! | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-124838@lists.php.net to get a copy of this message | ||
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')";
$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"];
mysql_db_query("DB_nac31915",$real) or die (mysql_error());
}
}
mysql_close();
?>