> 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