what should i add to my basic search ??

[yami007]

this is my code :

<?php
if(isset($_GET['query'])) {

				$query = "SELECT * FROM messages WHERE name LIKE '%{$_GET['query']}%' OR message LIKE '%{$_GET['query']}%' ";
				$result_set = mysql_query($query);
				while ($result = mysql_fetch_array($result_set)) {
					echo $result['name'].'<br />';
					echo $result['message'].'<br />';
				}

		}
?>

[mikesta707]

what to add depends on what results you want to get. How do you want to change your search query

[yami007]

ah sorry, forgot the main issue

what i need is when user type in something like "creed2" the query gets the the word "creed" and so on

[mikesta707]

Im not sure exactly what you want to do? Do you want to strip numbers from strings? or just strip the number two? or also search for creed as well as creed2? can you perhaps explain a little better or provide more examples

[yami007]

search for creed as well as creed2? can you perhaps explain a little better or provide more examples

[jon23d]

You need to escape your data prior to using it in a query.  Use mysql_escape_string on any user input prior to its insertion in SQL.  If you don't know why, google 'sql injection', but do it no matter what!

[yami007]

thanks for this, is helpful

but what i need actually is if the word "creedon" is not found on the db table, then if the word "creed" is found, get the results.

what function do i need to do that?