Help on previous question - no answer received

Help

Please see this thread. I haven't been able to get an answer yet


http://sitepointforums.com/showthrea...threadid=36963

Well, I see many people gave you good information in that thread. You could also go here:

http://www.phpbuilder.com/forum/

Ive been to php builder on earlier questions and was never answered on those (i came here and got the answers to those questions).

So anyone has an idea on how to implement it?
The answers I received in that thread doesn't help me, since i need a specific use for a search.

Well, you could keep trying new forums:

http://comptia-itpro.experts-exchang...ist.jsp?ta=php

http://zend.experts-exchange.com/

Hope this helps.:)

ignored at zends and dont know the other one. I'm on 10 boards and I dont need another one...

Jus someone please help. I've posted my source code already, just need someone to help set up a search engine

Another resource is the computer science department at a local college. There will definitely be someone who can help you there. You could post what you're doing on the bulletin board in the computer science department. And you could even sit in on a class and talk to the professor after class. If you stump him, then you are a BRAINIAC!:D

hi just had a look at my archives and pulled this one for you.
the process has 2 pages; form.php and results.php.
i havent had time to change any of the names of the fields...you'll need to do this.
also the script looks messy and needs some tweaking but i think it works.
hope this is what you were looking for.

form.php:

<h5>Retailer Search ::</h5>

<center><h1>Enter Search Criteria</h1></center>

<br><p>Enter your nearest city and refine your search with the retailer name and/or the post code.</P><br>

<form method="post" action="results.php">

<h6>RETAILER NAME</h6>
<input name="NAME" type="text" width=10>

<br><br><br>

<h6>CITY</h6>
<input name="ADDRESS2" type="text" width=10>

<br><br><br>

<h6>POSTCODE</h6>
<input name="POSTCODE" type="text" width=10>

<br><br><br>

<center><input name="Submit" type="submit" value="Submit">
</center>
</form>

results.php:

PHP Code:

---

<?
**connect to mysql here**

$query =  "SELECT * FROM $table WHERE NAME LIKE '%$NAME%' AND ADDRESS2 LIKE '%$ADDRESS2%' AND POSTCODE LIKE '%$POSTCODE%' ORDER BY NAME ASC LIMIT 5"; 


$result = mysql_query($query); ?>

<p>There were <?echo mysql_num_rows($result);?> records matching your  
query:</p> 


<?
WHILE ($myrow = mysql_fetch_array($result)) {

printf("<a href=\"view.php?id=".$myrow["ID"].">%s</a>\n", $myrow["NAME"]);
printf("<br>%s\n", $myrow["POSTCODE"]);
printf("<br>%s<br><br>\n", $myrow["TEL"]);
 

} 
?>

---