[RESOLVED] Fatal error: Call to a member function free() on a non-object

[bfulda]

Hey all,

Weird problem. I have all of my php pages set up the same. Cut/Paste with only the mysql part being different. I get this error message when I try to run it, but it works on the other pages!?! any ideas

<?php

//Create variable names from the html input
$limit=$_POST['limit'];
$keyword=$_POST['keyword'];

if (!get_magic_quotes_gpc())
{
$limit = addslashes($limit);
$keyword = addslashes($keyword);
}

if (mysqli_connect_errno())
{
echo 'ERROR: Could not connect to database. Check that the db is running and that the server is up.';
exit;
}
$query = "select * from sdata where
description like '%".$keyword."%' order by sdata.datetime desc limit '.$limit.'";
$result = $db->query($query);
$num_results = $result->num_rows;
echo '<p>Number of Records found: '.$num_results.'</p>';
for ($i=0; $i < $num_results; $i++)
{
$row = $result->fetch_assoc();
echo '<p><strong>Record #' . ($i+1) .'</p>';
echo stripslashes($row['name']);
echo '<br />ID: ';
echo stripslashes($row['id']);
echo '<br />Server: ';
echo stripslashes($row['server']);
echo '<br />Event Type: ';
echo stripslashes($row['event']);
echo '<br />Reference Number: ';
echo stripslashes($row['refnum']);
echo '<br />Datetime: ';
echo stripslashes($row['datetime']);
echo '<br />Description: <br /></strong>';
echo '<textarea rows="15" cols="80" "12">';
echo str_replace("<br />","",stripslashes($row['description']));
echo '</textarea>';
echo '<td style="text-align: center; background-color: rgb(51, 153, 153);"><a href="http://mt17.logsa.army.mil/search_page.
html"><big style="font-weight: bold;">Return to Search Page</big></a></td>';
echo '';
echo '';
}
$result->free();
$db->close();
?>

Fatal error: Call to a member function free() on a non-object
I will remove the variable limit and change to something else as that might be confusing the script??!!??
TIA,
brad

[NogDog]

See my answer in the PHP forum (and please avoid cross-posting the same question in multiple forums).

[bfulda]

Yeah sorry about that, that was a mistake. Had too many tabs up, thought I was in the correct forum. thanks again!