[Warning: mysql_fetch_array()]

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

[Warning: mysql_fetch_array()]

Does that make sense Russell?

[Warning: mysql_fetch_array()]

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/>';

 

 

<?php

// Declare the config as globals.

define('DB_USERNAME','freepspw');

define('DB_PASS','ungoah615233');

define('DB_HOST','localhost');

define('DB_NAME','freepspw_freepsp');

 

// 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);

?>

[Warning: mysql_fetch_array()]

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

[Error wont go away?]

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);
?>

[Error wont go away?]

 

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