$q="INSERT INTO proj select * from projtemp where projid ='".$projid."'";

[kkshansid]

$projid=$_GET['projid'];
$q="INSERT INTO proj select * from projtemp where projid ='".$projid."'";
 $qins=mysql_query($q);

is resulting false
is there any error?
there are 2 tables in a database with name proj and projtemp

[numberwhun]

$projid=$_GET['projid'];
$q="INSERT INTO proj select * from projtemp where projid ='".$projid."'";
 $qins=mysql_query($q);

is resulting false
is there any error?
there are 2 tables in a database with name proj and projtemp

First, I would make sure that when running this through the web page you are running it from, that it the sql statement returns what you expect.

Second, you could always try replacing the quote sequence you have, making this:

projid ='".$projid."'

with:

projid =\".$projid.\"

Sometimes its better to escape the double quotes to remove their meaning.

Regards,

Jeff

[kkshansid]

First, I would make sure that when running this through the web page you are running it from, that it the sql statement returns what you expect.

Second, you could always try replacing the quote sequence you have, making this:

projid ='".$projid."'

with:

projid =\".$projid.\"

Sometimes its better to escape the double quotes to remove their meaning.

Regards,

Jeff

it solved no of columns ware different in both tables