Hi !
How can i make advanced search with MySQL ?
If i have in STAFF -table value James Smith, how can i find that if i search using searchword 'Smi' or 'jame' ???
I have now code like this:
$query="SELECT * FROM staff WHERE ID = '$searchword' OR Name = '$searchword' OR Email = '$searchword' OR Telephone = '$searchword' ORDER BY Name";
Thx !!
How can i make advanced search with MySQL ?
If i have in STAFF -table value James Smith, how can i find that if i search using searchword 'Smi' or 'jame' ???
I have now code like this:
$query="SELECT * FROM staff WHERE ID = '$searchword' OR Name = '$searchword' OR Email = '$searchword' OR Telephone = '$searchword' ORDER BY Name";
Thx !!