Insert data to single table from multiple tables using SELECT in MySQL? here cus_order is my table having name,snap,price columns...name should be retrived from register table and snap,price...

<blockquote class="quote"><div class="op">Quote:</div>
<?php
	session_start();
	if(!(isset($_SESSION['unm']) && $_SESSION['unm']!=''))
	{
		header('location:index.php?dp=4');
	}
	else
	{
		$unm=$_SESSION['unm'];
		
		$con=mysql_connect("localhost","root","");
		$db=mysql_select_db("Project_Interior",$con);
		
		$query="select snap,SUM(price) from cart";
		$result=mysql_query($query);
		
		while($row=mysql_fetch_array($result))
		{
			$totbill=$row['SUM(price)'];	
			$snap=$row['snap'];
		}
		
		$nameQuery="select name from register where email_id='$unm'";
		$nameresult=mysql_query($nameQuery);
		
		while($row1=mysql_fetch_array($nameresult))
		{
			$name=$row1['name'];
		}
		
		$insquery="INSERT INTO cus_order (name,snap,price) ('$name',(SELECT snap,price from cart))";
		$insresult=mysql_query($insquery);
		
	}
	
?></blockquote>