if ( ($city = trim($_POST["city"])) != "" ) { if ( $getCity = @mssql_init("sp_getCity") ) { mssql_bind( $getCity , "@city" , $city , SQLVARCHAR ); mssql_bind( $getCity , "@idState" , $_POST["idState"] , SQLINT2 ); if ( $rsCity = @mssql_execute($getCity) ) { var_dump($rsCity); // echo mssql_num_rows($rsCity) .", ". $idState .", '". $city ."'
"; $row = mssql_fetch_array($rsCity); mssql_bind( $updateUser , "@idCity" , $row[0] , SQLINT2 ); } else $status_msg .= "

Could not modify CITY.
". mssql_get_last_message() ."

"; } }