trying to use a LIKE statement

[mikefly]

Hey all,
this is my first question here so i hope its not a dumb one lol.... im working on a site that has mulitple ways to query the DB the one that has me stumped is were the user types in the the name they are searching for...this would be easy but as ive already probably misspelled something in this post im taking that under consideration and im trying for the first time to use a LIKE statment and its not quit working correctly. if i type in the first letter of something im trying to query then i get results on every thing that has that letter or if i type in the name exactly as it appears in the DB i get the right response but again this wouldnt be an isssue if every one new how every thing was spelled. but if i type it in close but not right i get nothing... take a look and hopefully its something silly i missed

require ('sessions.php');
foreach($_SESSION as $key => $value) {
$key = $value;
}
$query = "SELECT * FROM database WHERE name LIKE'%$name'";
$result = mysql_query($query)
or die ("couldnt execute query." . mysql_error());
while ($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['type'] . "</td><td>" . $row['name'] . "</td><td>" . $row['address'] . "</td><td>" . $row['phonenumber'] . ;
}
thanks for taking a look

[dalecosp]

Well, I'm curious; if this is your first question, what were your other 10 posts? 😃

Anyway, I guess you've discovered that MySQL doesn't spell check. No answer there for you. At least, no easy one. You might try using the pspell/aspell library to suggest some alternate words and run a query on them, too, but you'll likely slow down your app a good bit...that's probably why Google, for example, only suggests one possible alternate spelling....