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**
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
