Invalid Argument ??? Not sure how to debug this

Hi all and Good Morning. I have been struggling with this code: I was wondering if someone could lend me a hand. I am working with this code and can't get the error to disappear. After running I get |-----------------------------------------------------------------------------------------| | Warning: Supplied argument is not a valid MySQL result resource in C:\My Documents\My | | Webs\php\TMPibtpit3zq0.php on line 12 | |-----------------------------------------------------------------------------------------| Line 12 happens to be the WHILE statement. I am not sure if it is the while statement or the results its looking for. TIA So far, i havent been able to sleep atleast until I get this. <html> <? if (isset($searchstring)) { $db = mysql_connect("localhost","webuser",""); mysql_select_db("cd_collection",$db); $sql= "SELECT * FROM cd_list WHERE $searchstring LIKE '%searchstring%' ORDER BY artist ASC"; $result = mysql_query($sql,$db); echo "<TABLE BORDER=2>"; echo "<tr><td><b>Artist</b><td><b>Title</b><td><b>Options</b></tr>"; while ($myrow = mysql_fetch_array($result)) { echo "<tr><td>".$myrow["artist"]."<td>".$myrow["title"]; echo "<td><a href=\"edit.php?id=".$myrow["cd_id"]." \">View</a>"; } echo "</TABLE>"; } else { ?> <form method="POST" action="<? $PHP_SELF ?>"> <table border="2" cellspacing="2"> <tr><td>Insert Your Search String Here.</td> <td>Search Type</td></tr> <tr> <td><input type="text" name="searchstring" size="28"></td> <td><select size="1" name="searchtype"> <option selected value="artist">Artist</option> <option value="title">Title</option> <option value="category">Category</option> </select></td> </tr> </table> <p><input type = "submit" value="Submit" name="B1"> <input type="reset" value="Reset"></p> </form> <? } ?> </html> **DAN**