Peter,
use something like
if ( mysql_num_rows( $result ) ) {
echo '<UL>';
while( list($company) = mysql_fetch_row($result) ) {
echo '<LI>'.htmlentities($company).'</LI>';
}
echo '</UL>';
}
the first line checks whether there are results (if no, we don't need to
display the <UL></UL> either.
The while runs until mysql_fetch_row returns false, which is the case
when all rows have been retireved.
htmlentitites($company) makes sure that no HTML special characters slip
through (like a company named '<E>-Buiz Inc'.
Ben
Peter Houchin wrote:
>
> 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]
--
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]
