[Resolved] Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
Hello, I know this question has been addressed here and in other places on the internet, but I can't seem to find a way to fix this error. Most people say "it is a problem with your query" and that you should try testing it against the database.
Well, I checked to make sure I was spelling everything correctly, and I even "checked it against the database"... I think... if that means going to the SQL tab and typing it into the box that says "Run SQL query/queries on database" (sorry I am very inexperienced with all of this). It returned with "Your SQL query has been executed successfully ( Query took 0.0002 sec )"
Anyway, below is the code, if someone would be able to help I would greatly appreciate it!
<?php
mysql_connect ("localhost", "username","password") or die (mysql_error());
mysql_select_db ("test");
$term = $_POST['term'];
$sql = mysql_query("select * from work where tags like '%$term%'");
while ($row = mysql_fetch_array($sql)){
echo 'ID: '.$row['ID'];
echo '<br/> File: '.$row['file'];
echo '<br/> Title: '.$row['title'];
echo '<br/> Description: '.$row['description'];
echo '<br/> Tags: '.$row['tags'];
echo '<br/><br/>';
}
?>
Edited 2 time(s). Last edit at 04/10/2011 01:40PM by Ella Durham.