View Single Post
Old 10-13-2011, 03:40 AM   PM User | #4
laural4705
New to the CF scene

 
Join Date: Jun 2006
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
laural4705 is an unknown quantity at this point
SOLVED IT! I used SESSIONS - thanks anyway

Code:
$tsql2 = "SELECT term, native_term FROM [mydb].[dbo].[terms] 
WHERE 
	(id_language='$id_language');";

	$params2 = array();
	$options2 =  array( "Scrollable" => SQLSRV_CURSOR_KEYSET );

	/* Execute the query. */
	$stmt2 = sqlsrv_query($conn, $tsql2, $params2, $options2);
	if( $stmt2 === false ) { die( print_r( sqlsrv_errors(), true )); }

	$row_count = sqlsrv_num_rows( $stmt2 );

if ($row_count === false) {
   		echo "Error in retrieveing row count."; }
		
		elseif ($row_count > 0) {

while( $row = sqlsrv_fetch_array( $stmt2, SQLSRV_FETCH_ASSOC) ) {

				$term=$row["term"];
				$native_term=$row["native_term"];

				$_SESSION[$term]=$native_term;
}


				}
laural4705 is offline   Reply With Quote