Comparing post titles with a variable

[alqadir]

Hello all,
I was wondering if someone out there can help me out with some sql code. I am wanting to create a query that will search all the posts in the post table and compare the titles to a variable (say $formtitle). If it finds a match it will return the threadid of the matching title; thier can only be one matching title in the post so the limit should be one.

I have this so far but it is not working

$formtitle= "$answer1 $answer2)
$prevpost = $DB_site->query_first("SELECT * FROM post WHERE post.title='$formtitle' LIMIT 1");


I was wondering would I have to use the string compare command for this to work

[rake]

do you want the title to be EXACTLY the string you are searching for or not?

also:

$formtitle= "$answer1 $answer2)

should be:

$formtitle= "$answer1 $answer2";

[alqadir]

Yes I would like the title to match character for character.

opps. the $forumtitle should read the way you corrected it, I guess I was typing too fast. ;) thanks

[rake]

hrmm.... try this:

SELECT * FROM post WHERE post.title LIKE '$formtitle' LIMIT 1

[Dean C]

Use LIKE '%$formtitle%' if you want to match the pattern of that string in any occurence of any other string. E.g. Dan would match Danni :)

[alqadir]

both solutions did not work :( any other suggestions guys

[cinq]

Odd, previous solutions provided should work.

ie.

$prevpost = $DB_site->query("SELECT threadid FROM post WHERE title LIKE '%$formtitle%' LIMIT 1");
if($result=$DB_site->fetch_array($prevpost))
{
$output = $result['threadid'];
}


With $formtitle being the variable you want to compare the post table with to find a post with similar title.

$output should return the result ( threadid ) if there is such a match.