Search Script

[vbnah]

Hell everyone, I've been making a search script for my website. Iam having troubles with the MySQL databasing though.

What object would query a table for keywords...

Thanks

[AWC_Joe]

Heres a few ive used:
# general search
WHERE search_field LIKE '%".$_GET['q']."%'
# starts with letter "whatever"
WHERE search_field LIKE '".$_GET['q']."%''
# startes with number
WHERE search_field LIKE '[0-9]%''
# working with numbers, greated-then and less-then
WHERE search_field < '1970'


_

[vbnah]

Ok so the code

# general search
WHERE search_field LIKE '%".$_GET['q']."%'


Basically searches for keywords 'q',

[AWC_Joe]

Nope...

$_GET['q']
Will pull the info attached to the url.com?q=whatever

This would search for the keyword q WHERE search_field LIKE '%q%'

WHERE search_field LIKE '%search word%'

_

[vbnah]

Ok great thanks for the help!