Custom CMS with SQL and PHP > Error

[Mitchell Ransom]

Hi Guys,

First post here. I'm not quite a beginner with PHP but I still have a hell of a lot to learn. I'm receiving the following error with one of my scripts:

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/neonflam/public_html/subdomains/moleseyhire.com/php/manageAdverts.php on line 34

 

Here below are the related code snippets;

 

manageAdverts.php

<?php
require_once"include/init.php"; 
include_once( "dbController.php" );
dbController::init();
$adverts = dbController::getAllAdverts();
$_SESSION['redirectedpage'] = "manageAdverts.php";
?>
<?php
while($row = mysql_fetch_array($adverts)) {
?>

 

dbController.php

function getAllAdverts(){
	$query = "SELECT * FROM local_adverts";
	return self::execQuery($query);
}

 

If anyone can point me in the right direction that would be great!

 

Kind regards,

Mitchell Ransom

[PeoMachine]

Give us the "execQuery" method. Maybe youre not returning the MySQL resource.