mysql error message

[MDanz]

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ... at line 1"

 

i don't see whats wrong?

if ($rs = $rss->get($rssurl)) {
    
$title = $rs['items'][0]['title'];
$description = $rs['items'][0]['description'];
$link = $rs['items'][0]['link'];

$connect =mysql_connect("localhost","Master","pword");
              mysql_select_db("stack"); 
		  
		  
		  
 $sql2 = "SELECT * FROM `Stacks` WHERE name='$title'";
    	   $bad = mysql_query($sql2) or die(mysql_error());
      if (mysql_fetch_row($bad) > 0)
      {
         echo "<font color=white><strong>Title in use, please choose another. </strong></font>";
      }

[PFMaBiSmAd]

It would really help if you posted the whole sql error message, but best guess is that $title contains a special sql character, like a single-quote, that is breaking the syntax of the query.

 

You must escape all string data put into a query if it could contain any special sql characters. See this link - mysql_real_escape_string