Ok so I'm stuck.
This is the site on its current server
www.police-information.co.uk
When we transfer it to the new server we get a constant list of errors.
Temp domain where all errors appear
www.vc-hosting.net
The same error appears throughout the site,
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in/home/policein/public_html/includes/popup_ad.html on line 5
If I look at the code for this file;
PHP Code:
<?php
$uri = $_SERVER['REQUEST_URI'];
$q = "SELECT cms_area7 FROM pages WHERE uri = '$uri'";
$r = mysql_query($q);
$row = mysql_fetch_array($r);
$c = $row['cms_area7'];
$q = "SELECT content FROM content WHERE content_id = '$c'";
$r = mysql_query($q);
$row = mysql_fetch_array($r);
echo $row['content'];
?>
All the errors relate to the exact same line of code that is present throughout all the files which is this one
PHP Code:
$row = mysql_fetch_array($r);
Any help would be greatly received.
Thanks