search code in php

[lakshmiyb]

hi,

i have the 4 fields in my form, and when they are filled i have to get the search result from the database,

when all the fields are filled i am able to get the result, but when 1 or 2 fields are filled i am not ablr to get the result,

what should be changed in the query to do this

this is my query

SELECT movie_thumbnail,thumb_name FROM movies where language ='".$languages."'and movie_genres ='".$genres."' and actor='".$malelead."'and  actress='".$femalelead."';

[Weedpacket]

Don't put bits into the query to search fields that haven't been filled in. If $malelead is blank then your query will be searching for films where the actor='' and there probably aren't many of those.

$criteria = array();
if(!empty($languages))
{
    $criteria[]='language='".$languages."'";
}
if(!empty($genre))
{
    $criteria[]=movie_genres='".$genre."'";
}
...and so on

if(!empty($criteria))
{
Do something with
'SELECT movie_thumbnail,etc from movies where '.join(" and ", $criteria)
}
else
{
// everything was blank! What to do?
}

Although there are much more sophisticated approaches, based on what you've given it's impossible to tell how suitable they'd be.

[lakshmiyb]

thank u for the sugession
but i am able to display only the text
i.e, language='english' genres='genres' and soon, but i am not able to display the thumbnail from the database

[Weedpacket]

Well, that sounds like a totally different question (one that has been answered more than once in these forums, so perhaps searching for "image" and "database" would give results), and should (if it's still necessary after that search) be asked in a different thread.