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

2001-02-14 Thread CC Zona
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

2001-02-14 Thread Ben Peter
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

2001-02-14 Thread Peter Houchin
: 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

2001-02-14 Thread Ben Peter
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);