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.

if (isset($searchstring))

     $db = mysql_connect("localhost","webuser","");
     $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"]."
          echo "</TABLE>";
          <form method="POST" action="<? $PHP_SELF ?>">
          <table border="2" cellspacing="2">
          <tr><td>Insert Your Search String Here.</td>
          <td>Search Type</td></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>
          <p><input type = "submit" value="Submit" name="B1">
          <input type="reset" value="Reset"></p>



PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to