Php, new.php?id="180" doesnt work, but new.php?id=180 works fine on apache,but new.php?id="180" works iis:

Question

Hi

Problem:
http://localhost/www.website.com/new.php?id="180"
returns error as follows:
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 '\"180\"' at line 1


This works!:
http://localhost/www.website.com/new.php?id=180

Thing is i dont know ho to chnage my code to get rid of the double quotes!

On iis :http://localhost/www.website.com/new.php?id="180"
works fine, but on apache it doesnt!


whay is this?
What shall i do?




index.php:
print "id\">$row->title";



new.php:
include("db/db_config.php");

{
$id = $_GET["id"];
$sql = "SELECT * FROM articles WHERE id = $id";
}

// $sql = "SELECT id,datetime,title,author,body,author_box FROM t4d.articles WHERE id = $_GET["id"] LIMIT 1";
$rs = mysql_query($sql) or die(mysql_error());


Thanks in advance

Tovia Singer

Answer 1

print ''.$row->title..

Answer 2

without the quotes should work for both and that is the convention.. it is assumed that everything from the = to either & or the end of the URL is a string and will be interpreted by php as such

if you do need to get rid of the quotes you can do: str_replace('"", '', $id);
however it would be better to change the url not the code

Answer 3

9 out of 10 cats prefer Whiskers

Answer 4

The dirty way:
$sql = str_replace('"','',$sql);

A better way is to fix all your links

Answer 5

try harder

1 out of ten cats doesn't like whiskers