sql queries

[elle_girl]

$itemId = "SELECT itemId FROM cart";
			 $result1 = mysql_query($itemId) or die(mysql_error());
			 $price = "SELECT price FROM cart";
			 $result2 = mysql_query ($price) or die(mysql_error());
			 $qty = "SELECT qty FROM cart";
			 $result3 = mysql_query ($qty) or die(mysql_error());
			 $id = mysql_fetch_array ($result1, MYSQL_NUM);
			 $pr = mysql_fetch_array ($result2, MYSQL_NUM);
			 $q = mysql_fetch_array ($result3, MYSQL_NUM);

         $query1 = "INSERT INTO view (account_no, token_id, name, address, postcode, state, country, itemId, qty, price) VALUES ('$aa','$t','$n','$ad','$p','$s','$c','$id', '$q', '$pr' )"; 
         $result4 = mysql_query($query1) or die(mysql_error());// Run the query. 

When I am trying to stored the data to the table view? It cannot stored. Especially for itemid,qty and price it appear 0,0.00 and NULL. Can you please help me to overcome this problem?

[laserlight]

Where is $aa, $t etc coming from?

[elle_girl]

It come from here.

require_once ('./mysql_connect.php'); // Connect to the db 
      	 // Create a function for escaping the data. 
  	 function escape_data ($data) { 
      		global $dbc; // Need the connection. 
      		if (ini_get('magic_quotes_gpc')) { 
         		$data = stripslashes($data); 
      	} 
      	return mysql_real_escape_string($data, $dbc); 
  	 } // End of function. 



$message = NULL; // Create an empty new variable. 



 // Check for the account number. 
if (empty($_POST['account_no'])) { 
  		$aa = FALSE; 
  		$message .= '<p>You forgot to enter your account number!</p>'; 
} else { 
  		$aa = escape_data($_POST['account_no']); 
} 

 if (empty($_POST['token'])) { 
  		$t = FALSE; 
  		$message .= '<p>You forgot to enter your reference ID!</p>'; 
} else { 
  		$t = escape_data($_POST['token']); 
} 

if (empty($_POST['name'])) { 
  		$n = FALSE; 
} else { 
  		$n = escape_data($_POST['name']); 
} 

if (empty($_POST['address'])) { 
  		$ad = FALSE; 
      	} else { 
  		$ad = escape_data($_POST['address']); 
} 

if (empty($_POST['postcode'])) { 
  		$p = FALSE; 
      	} else { 
  		$p = escape_data($_POST['postcode']); 
} 

if (empty($_POST['state'])) { 
  		$s = FALSE; 
      	} else { 
  		$s = escape_data($_POST['state']); 
} 

if (empty($_POST['country'])) { 
  		$c = FALSE; 
      	} else { 
  		$c = escape_data($_POST['country']); 
}