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

[PHP] SELECT BLAH WHERE BLAH LIKE BLAH not working

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) .. . . . \n\nCompan