[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) .. . . . form

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

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\"

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):

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 '%$query%'&quo

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

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);