Re: [PHP] SELECT BLAH WHERE BLAH LIKE BLAH not working

001 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

RE: [PHP] SELECT BLAH WHERE BLAH LIKE BLAH not working

: 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 > '%$

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_

Re: [PHP] SELECT BLAH WHERE BLAH LIKE BLAH not working

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("Peter Houchin") wrote: > > > > > echo " BGCOLOR=\"#CC\" ALIGN=\"CENTER\">\n\n bgcolor=\"#006699\"> sans-serif\" size=\"3\" color=\"#FF\">Company "; > $result = mysql_query("SELECT company FROM resellers WHERE Company LIKE > '%$quer