SitePoint Sponsor

User Tag List

Results 1 to 7 of 7

Hybrid View

  1. #1
    SitePoint Enthusiast WizyWyg's Avatar
    Join Date
    Sep 2001
    Posts
    76
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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

  2. #2
    Pixels Matter! Jimknee's Avatar
    Join Date
    Jul 2001
    Location
    Island Paradise :D
    Posts
    835
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well, I see many people gave you good information in that thread. You could also go here:

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

  3. #3
    SitePoint Enthusiast WizyWyg's Avatar
    Join Date
    Sep 2001
    Posts
    76
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.

  4. #4
    Pixels Matter! Jimknee's Avatar
    Join Date
    Jul 2001
    Location
    Island Paradise :D
    Posts
    835
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well, you could keep trying new forums:

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

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

    Hope this helps.

  5. #5
    SitePoint Enthusiast WizyWyg's Avatar
    Join Date
    Sep 2001
    Posts
    76
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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

  6. #6
    Pixels Matter! Jimknee's Avatar
    Join Date
    Jul 2001
    Location
    Island Paradise :D
    Posts
    835
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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!

  7. #7
    SitePoint Enthusiast
    Join Date
    Jun 2001
    Posts
    54
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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"]);
     


    ?>
    Last edited by kamstar; Oct 26, 2001 at 08:38.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •