Could anyone explain what this might mean?
Warning: 0 is not a MySQL result index
I have a simple form set up where a user types in a keyword and then a page is displayed based on the keyword. See below
<form action="submitform.php3" method="GET">
<p><strong><font face="verdana, arial, ms sans serif" size="1">id#</font>:</strong> <input
type="text" name="keyword" size="15" maxlength="25"> <input type="submit" value="Go!"> </p>
mysql_connect ("localhost", "username", "password");
$result=mysql_query("SELECT $url FROM table
WHERE keyword LIKE '%$keyword%'");
The concept is really simple. A user types in an keyword and that page is displayed. There is a database set up with a table that has two columns. One is "keyword" and the other is "url" For example row 1 the keyword is abc, and the url is http://www.abc.com.