Item Searching

[Stotty]

Right im quite new to PHP and im making a new website and i need a little tool on it

 

Like this

 

http://www.zybez.net/items.php

 

But not as High complex as that

 

All i need is a blank form like this on homepage

 

Saying Search : Form Here

 

then under that in a table displays 3 random items from the database

 

then when u search it searches by letter Like say i had one Called PHP Freaks

 

i could type P to get to it not the Hole word like PHP Freaks

 

im willing to give donations ( when my site starts getting )  to whoever can make it full credit

 

Thank you in advanced

[Stotty]

Also if someone is going to make it is it possible to add The Images ?

[Stotty]

Anyone ?

[daalouw]

Stotty

 

You will need wildcard matching.  Assuming you're searching for an organization name in a database...

 

<?php   

$search = htmlspecialchars($_GET['searchfield']);

 

if (!get_magic_quotes_gpc())

{

  $search = addslashes($search);

}

 

$words = explode(" ", $search);

$phrase = implode("%' AND organization LIKE '%", $words);

   

$query = "SELECT organization, contactname, contacttitle from organization where organization like '%$phrase%'";

$result = mysql_query($query) or die('Could not query database at this time');   

 

?>

 

Deon

[daalouw]

By the way, my above example search for more than 1 field.