I have an HTML form that lets the user write what they want to search for. In this case a Name.

The form works, but it's in the php. I don't know what I have to write to get MySQL to search the database for what the user has input.

Here is the line where I get stuck:

```
$result = mysql_query("SELECT * FROM {$table} WHERE name = 'What do i gonna write
here? (take away the ' ");

```

I'm using PHP 5.