selective SELECTing

[acpaulley]

I have a db of Movie Titles, stars, descriptions, etc...

I have a PHP page that lists all of the movies in a nice table. At the bottom of the table is a form for users to enter data to filter the table.

In this case, I am successfully passing the variable $title back to the script.

My current query is:

$result = mysql_query ("SELECT * FROM movies ORDER by title");

How do I alter that to list the records whose title CONTAINS the variable $title.

I have tried:

$result = mysql_query ("SELECT * FROM movies (WHERE title LIKE $title) ORDER by title");

But even if I enter the title exactly, I can't seem to get it filter right.

Any ideas?

[cgraz]

SELECT * FROM movies WHERE title LIKE '%$title%'

The percents are wildcards on each side. If $title is coming from a form, you'll need to use $_POST or $HTTP_GET_VARS

SELECT * FROM movies WHERE title LIKE '%" . $_POST["title"] . "%'

Cgraz

[acpaulley]

I've set $title outside the questy by using the $_POST function... Have checked it with an echo and it is set right, so would my query then look like this:

SELECT * FROM movies WHERE title LIKE '%$title%'

?

Thanks for your quick response... wasn't expecting such a quick turnaround!

[cgraz]

yup

Cgraz

[acpaulley]

Awesome ... worked perfect. And to think... two nights ago I didn't know what PHP was.

[cgraz]

well you're moving along rather quickly. Good luck.

Cgraz