it looks like what your sql statement is doing is returning the first row in the table
Assuming the user is logged in, could you not ditch the recordset and use $_SESSION['UserID']
<!doctype html>
<html>
<?php
@session_start;
if ($_SESSION['UserID'] = 6) {
header("Location: http://www.domain.co.uk/product_contents_results.php"); /* Redirect browser */
} else {
header("Location: http://www.domain.co.uk/news_results.php"); /* Redirect browser */
} ?>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>
<body>
</body>
</html>