Copy a record in same table?

[mshen]

I have a big table.there are 40 fields.now I want to copy a record.

Firstly I use SQL SELECT statement to get the record data.then I save all the data to 40 temprary variables.finally I use SQL INSERT statement to add all data to a new record.

The problems are listed here.

1.I have to use 40 temprary variables.
2.the INSERT statement is very long(set va=a,vb=b,.....)
3.easy to make mistake.
4.I have to communicate with DB two times.

Do you have a easy way to do this.

Thanks a lot.

[barand]

Iknow this is a smaller table than yours but the principle is what matters. If you don't have a primary key you can select '*' otherwise list all fields except those in primary key.

$res = mysql_query("select description,parent from tablea where id = 1");
$row = mysql_fetch_row($res);
for ($i=0; $i<count($row); $i++) {
	$flds[] = mysql_field_name($res,$i);
	if (mysql_field_type($res,$i)=='string') $row[$i] = "'".$row[$i]."'";
	if (is_null($row[$i])) $row[$i]='NULL';
}
$sql = "insert into tablea (". join(',',$flds).") values (" . join(",",$row) . ")";
mysql_query($sql) or die (mysql_error());
echo "<br>$sql<br>";

hth

[mshen]

Good idea.

if the line 4 support to be like this:

$flds[$i] = mysql_field_name($res,$i);

Thanks

[barand]

$array[] = $variable

appends $variable to the next position in the array.

So

$array[] = 'a';
$array[] = 'b';
print_r($array)

gives

array (
[0] => 'a'
[1] => 'b'
)

[mshen]

do you mean both way is fine? right?

Thanks.

[barand]

Right