Query Value from one table and insert into another table.

I wonder if possible on page load to query the value of a specific colmn and insert the result into another table. My query looks like so

[PHP]
<?
include("include/session.php");
?>
<?
$usr = "xxxx";
$pwd = "xxxxx";
$db = "xxxxx";
$host = "xxxxxx";

# connect to database
$cid = mysql_connect($host,$usr,$pwd);
mysql_select_db($db);
if (mysql_error()) { print "Database ERROR: " . mysql_error(); }

$result = mysql_query("INSERT INTO audio SELECT pid FROM pix WHERE username='$session->username'");

?>
[/PHP]

I guess the result I'm trying to acheive is that when the page is opened the above query is executed and the pid is queried base of username and inserted into the audio table. I'm not getting any error messages from the query but pid is not being inserted into the audio table..any ideas!

re: Query Value from one table and insert into another table.

What is your version of MySQL?

Subash :)

re: Query Value from one table and insert into another table.

Hi,


Better do the following :

1. Select the value from the table and put into an recordset

2. Then insert the recordset value into the table

Subash :)

re: Query Value from one table and insert into another table.

What is a recordset?

re: Query Value from one table and insert into another table.

Okay I did a little research on the term and I'm kinda familiar with it now. When I get home I will create the recrord set query.. I will follow up latter..

Thanks you for the sugestion...

re: Query Value from one table and insert into another table.

I've been hacking away at this for hours with no luck. Record set seem to be a little complicated for the task at hand.

re: Query Value from one table and insert into another table.

Sorry for leaving this one open so long. This is another one solved. Thanks for the advice. But I found a better solution...

re: Query Value from one table and insert into another table.

If it's possible, could you share the solution so it may help others in a similar situation. Thanks.