In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] ("Peter Houchin") wrote:
> <form name=search method=POST action="<? $PHP_SELF ?>">
> <input type="text" name="query">
> <input type="submit" name="submit" value="submit">
> </form>
> <? if ($submit){
> echo "<TABLE BORDER=\"0\" CELLPADDING=\"3\" CELLSPACING=\"1\"
> BGCOLOR=\"#CCCCCC\" ALIGN=\"CENTER\">\n<tr BGCOLOR=\"#CCCCCC\">\n<td
> bgcolor=\"#006699\"><div align=\"center\"><font face=\"Helvetica,
> sans-serif\" size=\"3\" color=\"#FFFFFF\"><b>Company</b> </td></tr>";
> $result = mysql_query("SELECT company FROM resellers WHERE Company LIKE
> '%$query%'");
> printf("<tr><td> $company </td></tr>\n");
> echo "</table>";
> echo mysql_error();
> }
> ?>
Are you establishing a valid database connection someplace earlier in the
script? If not, then you need to do so first (see mysql_connect
mysql_pconnect, for instance). Also, the resource id for that connection
should be included as the second parameter in your mysql_query() call. You
may find it helpful to read the PHP manual section on mysql and/or a
PHP/MySQL tutorial (ex. phpbuilder.com).
--
CC
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
