Re: Invalid Argument ??? Not sure how to debug this

Daniel, $myrow["artist"] and $myrow["title"] might be a good place to start. It looks like all your ; are in place. I don't think you can place " inside [] like that: echo "<tr><td>".$myrow["artist"]."<td>".$myrow["title"]; > I have been struggling with this code: I was wondering if someone could > lend me a hand. > 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** -- John Taylor-Johnston ----------------------------------------------------------------------------- ' ' ' Collège de Sherbrooke: ô¿ô http://www.collegesherbrooke.qc.ca/languesmodernes/ - Université de Sherbrooke: http://compcanlit.ca/ 819-569-2064