MYSQL / PHP Query Help

[seanpatten11]

I have the following MYSQL Query:

 

Basically, the query will not work when i add quotes to the string. I want it to select from e-mails database where subject LIKE '%"$stringservername"%'

 

If I do just '%$SERVERNAME%' it works :S - And the mysql data includes the quotes.

 

I use the $strongservername to add the quotes.

 

 

$stringservername = "&quot$servername&quot";

$stringjobname = "&quot$vjobname&quot";

 

$queryemails = mysql_query("SELECT * FROM `emails` WHERE `subject` like '$searchstatus' AND `subject` like '%$stringservername%' AND `subject` like '%$stringjobname%' AND `fromemail` = '$matchfrom'");

 

 

 

Any suggestions?

 

Thankyou

 

[AyKay47]

not fully understanding..

why are you manually adding quotes to your search criteria?

it looks like $queryemails should work.. im assuming that it doesn't?