MYSQL Query Issue

[tomtimms]

I have a query that is searching if something exists in my database.  I have URL's stored in my database and when I tried to run a query to check I get the error:

 

There was an issue with this query: SELECT * FROM sites WHERE url = http://www.mysite.net AND id =3Error: 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 '://www.mysite.net AND id =3' at line 1

 

My query is the following.

 

    $sql = "SELECT * FROM sites WHERE url = ".mysql_real_escape_string($url)." AND id =".$id."";

 

Anyone know why it won't search the whole URL?

[tomtimms]

Nevermind, I figured out my issue...stupid '' missing.