potter_gold

Russell, That is amazing cheers. I inserted the code you suggested and it popped up to tell me that it could not find categories. This was because there was no such table in my php admin. I have changed to the required database. Many thanks. I will also change passwords as suggested - Good call. Peter

Does that make sense Russell?

Sorry russ, im very new. This is the file which it states a problem with line 22 is this line while ($row = mysql_fetch_array($query)) { $catlinks .= ' <img src="bullet.gif" width="7" height="7" border="0" align="center"><a href="viewcategory.php?cid='.$row['wallpaperid'].'">'.$row['categoryid'].'</A><br/>';

Hi All, I am sorry to bother you but wondered if you might be able to spot my mistake... When I click on this page http://www.freepspwallpaper.co.uk/free-psp-wallpapers/free-babes-psp-wallpapers/ if returns an error as below (look carefully its hidden behind the header color). Im a bit of a newbie and cannot seem to remove it. Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/freepspw/public_html/dbconnect.php on line 22 Can anyone help? Peter

So sorry Fenway. This is the error while ($row = mysql_fetch_array($query)) { $catlinks .= ' <img src="bullet.gif" width="7" height="7" border="0" align="center"><a href="viewcategory.php?cid='.$row['wallpaperid'].'">'.$row['categoryid'].'</A><br/>'; } ----- This is the rest of the code within my dbconnect file - minus rows for usernames and passwords. // Connect to the database. $database_connection = mysql_connect(DB_HOST, DB_USERNAME, DB_PASS); mysql_select_db(DB_NAME); require('class.pagedresults.php'); // Create the navbar. // Select what we want. $sql = 'SELECT * FROM `categories`'; $query = mysql_query($sql); $catlinks = ' <img src="bullet.gif" width="7" height="7" border="0" align="center"><a HREF="http://www.freepspwallpaper.co.uk">Home</A><br/>'; while ($row = mysql_fetch_array($query)) { $catlinks .= ' <img src="bullet.gif" width="7" height="7" border="0" align="center"><a href="viewcategory.php?cid='.$row['wallpaperid'].'">'.$row['categoryid'].'</A><br/>'; } $template = file_get_contents('template.php'); $template = str_replace('{LINKS}',$catlinks,$template); ?>

Hi My first post, I have an error on a query and do not know how to fix it. Can anyone help me? Peter It is as follows and appears on this page http://www.freepspwallpaper.co.uk/free-psp-wallpapers/free-babes-psp-wallpapers/ Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/freepspw/public_html/dbconnect.php on line 22