mysql_fetch_array(): supplied argument is not a valid MySQL result resource

I've been getting this error below:

mysql_fetch_array(): supplied argument is not a valid MySQL result
resource

When running this code, I can't seem to figure out what is wrong.

require_once('functions.php');

$search = $_POST['term'];
$field = $_POST['field'];

do_html_header();

//query
$conn = db_connect();
$result = $conn->query("SELECT city, restaurant FROM massachusetts
WHERE $field LIKE '%$search%'");
if (!$result)
return false;


//And we display the results
while($data = mysql_fetch_array($result))
{
echo $data['city'];
echo " ";
echo $data['restaurant'];
echo "
";
echo "
";
}

do_html_sidebar();
do_html_footer();

?>

my db_connect(); function is below (with the login information
changed):

function db_connect()
{
$result = new mysqli('localhost', 'user', 'password', 'database');
if (!$result)
throw new Exception('Could not connect to database server');
else
return $result;
}

And this is my search form where it gets the post variables:

Re: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

Dan wrote:
> I've been getting this error below:
>
> mysql_fetch_array(): supplied argument is not a valid MySQL result
> resource
>
> When running this code, I can't seem to figure out what is wrong.
>
> > require_once('functions.php');
>
> $search = $_POST['term'];
> $field = $_POST['field'];
>
> do_html_header();
>
> //query
> $conn = db_connect();
> $result = $conn->query("SELECT city, restaurant FROM massachusetts
> WHERE $field LIKE '%$search%'");
> if (!$result)
> return false;
>
>
> //And we display the results
> while($data = mysql_fetch_array($result))
> {
> echo $data['city'];
> echo " ";
> echo $data['restaurant'];
> echo "
";
> echo "
";
> }
>
> do_html_sidebar();
> do_html_footer();
>
> ?>
>
> my db_connect(); function is below (with the login information
> changed):
>
> function db_connect()
> {
> $result = new mysqli('localhost', 'user', 'password', 'database');
> if (!$result)
> throw new Exception('Could not connect to database server');
> else
> return $result;
> }
>
> And this is my search form where it gets the post variables:
>
>

Re: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

> while($data = mysql_fetch_array($result))

I have not used the mysqli class but try using $result->fetch_array()
instead of the function

You are using a class as the resource id instead of an actual resource id.

Re: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

> is 'query' a valid function? perhaps that should be 'mysql_query'?

query is a valid method in the mysqli class:-

http://www.php.net/manual/en/function.mysqli-query.php

Re: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

"Dan" wrote in message
news:1164843525.434746.8190@80g2000cwy.googlegroups.com...
> I've been getting this error below:
>
> mysql_fetch_array(): supplied argument is not a valid MySQL result
> resource
>
> When running this code, I can't seem to figure out what is wrong.
>
> > require_once('functions.php');
>
> $search = $_POST['term'];
> $field = $_POST['field'];
>
> do_html_header();
>
> //query
> $conn = db_connect();
> $result = $conn->query("SELECT city, restaurant FROM massachusetts
> WHERE $field LIKE '%$search%'");
> if (!$result)
> return false;
>
>
> //And we display the results
> while($data = mysql_fetch_array($result))
> {
> echo $data['city'];
> echo " ";
> echo $data['restaurant'];
> echo "
";
> echo "
";
> }
>
> do_html_sidebar();
> do_html_footer();
>
> ?>
>
> my db_connect(); function is below (with the login information
> changed):
>
> function db_connect()
> {
> $result = new mysqli('localhost', 'user', 'password', 'database');
> if (!$result)
> throw new Exception('Could not connect to database server');
> else
> return $result;
> }
>
> And this is my search form where it gets the post variables:
>
>

Re: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

try @mysql_fetch_array