thanks ben it works :)
Just one thing if i say enter just one letter .. how could i make it show
more than just the one result?
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Ben Peter
Sent: Thursday, February 15, 2001 2:23 PM
To: Peter Houchin
Cc: PHP MAIL GROUP
Subject: Re: [PHP] SELECT BLAH WHERE BLAH LIKE BLAH not working
Peter,
after querying the database, you need to fetch the returned values from
the result before you can use them:
> $result = mysql_query("SELECT company FROM resellers WHERE Company LIKE
> '%$query%'");
$row = mysql_fetch_row($result);
$company = $row[0];
OR (shorter):
list($company)=mysql_fetch_row($result);
> printf("<tr><td> $company </td></tr>\n");
otherwise, $company would not be set.
Ben
Peter Houchin wrote:
>
> Hiya, i was wondering if some one could help me with this ... i have a
> little form where you can enter a value say company then on submit its
ment
> to check the db for value or one like it my sql line works fine
> (mysql_error() shows nothing and it works from command line) ..
>
> .
> .
> .
> <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();
> }
> ?>
>
> Thanks in advance
>
> Peter
--
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]
--
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]
