Try ...
If ($result = ...)
{ ...
...
} else echo(mysql_error());
I always do querying like this anyway (without the error echo in live stuff
obviously)
Tim Ward
Internet Chess www.chessish.com <http://www.chessish.com>
----------
From: Daniel Negron/KBE [SMTP:[EMAIL PROTECTED]]
Sent: 17 March 2002 08:38
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: 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**
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
