Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Sep 2010
    Posts
    6
    Thanks
    1
    Thanked 0 Times in 0 Posts

    mysql_fetch_array Error

    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

  • #2
    New to the CF scene
    Join Date
    Sep 2010
    Posts
    6
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Its ok - I have resolved this thank you


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •