database Search

[PyraX]

Hi, I have searched for but have been unable to find a semi advance search script for searching a database.

 

Im after simple things like "keyword" and -keyword etc.

 

Thanks in advance

 

PyraX

[Daukan]

<?php
$query = "
    SELECT * 
    FROM `table' 
    WHERE `name` 
    LIKE '%$findme%'";
?>

 

That searches the whole field for any part of $findme

If you want to find a word starting with $find just use the fist %

<?php
$query = "
    SELECT * 
    FROM `table' 
    WHERE `name` 
    LIKE '%$findme'";
?>

 

I don't how fancy your searches need to be but thats the basic way to do searches, unless you need to search TEXT fields, that uses a different approach

[PyraX]

thanks Daukan

 

I was looking for something a bit more advanced, looks like I will be doing all the custom stuff myself