|
|
Posted by Dan on 11/29/06 23:38
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.
<?php
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 "<br>";
echo "<br>";
}
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:
<form method='post' action='performsearch.php'>
<table bgcolor='#cccccc'>
<tr>
<td>Search here:</td>
<td><input type='text' name='term'></td>
<td><Select NAME="field">
<Option VALUE="college">college</option>
<Option VALUE="restaurant">restaurant</option>
<Option VALUE="phone1">phone</option>
</Select></td></tr>
<tr>
<td colspan=2 align='center'>
<input type='submit' value='Search'></td></tr>
</table></form>
Can anybody help? Thanks
Navigation:
[Reply to this message]
|