Parse error...T_STRING

[Meltdown]

Hi everyone, I'm new to PHP and have a prob with what should be simple script. I keep getting the following error:

Parse error: parse error, unexpected T_STRING in C:\web\viewguestbook.php on line 7

It seems to be this line:
$result = mysql_query(“select * from guestbook”);

I've checked the db and the table and fields exist.

Full Script:
<?
$db = mysql_connect(“localhost”,“root”,”my_password”);
mysql_select_db(“guestbook”,$db);
?>
<h2>View My Guest Book!!</h2>
<?php
$result = mysql_query(“select * from guestbook”);
while ($row = mysql_fetch_array($result))
{
echo “<b>Name:</b>”;
echo $row [“name ”];
echo “<br>\n ”;
echo “<b>Location:</b>”;
echo $row [“location ”];
echo “<br>\n ”;
echo “<b>Email:</b>”;
echo $row [“email ”];
echo “<br>\n ”;
echo “<b>URL:</b>”;
echo $row [“url ”];
echo “<br>\n ”;
echo “<b>Comments:</b>”;
echo $row [“comments ”];
echo “<br>\n ”;
echo “<br>\n ”;
echo “<br>\n ”;
}
mysql_free_result($result);
?>
<h2><a href=”sign.php ”>Sign My Guest Book!!</a></h2>

Thanks for any help

[laserlight]

To be honest, I cant quite see what is wrong.

I suggest testing with an even simpler script.

I'm not sure what script to test with though, but you could try:

<?php
$db = mysql_connect("localhost", "root", "my_password");
mysql_select_db("guestbook", $db);
if (mysql_query("select * from guestbook"))
	echo "Query ok";
else
	echo mysql_error();
?>

[Meltdown]

Thanks for the reply laserlight, I tried your script and that came back as "Query OK".

[laserlight]

well, we know that your DB-related code seems ok.

I noticed that the characters you use for double quotes seem different from those I use, could that be the problem?

[Meltdown]

Laserlight...you are a genius!...I had copied and pasted the code from a PDF book. I would never in a million years have though there could be an issue with "different" types of double-quotes.

When I deleted them and put them in again from my keyboard it worked perfectly.

Many thanks again for your help

Meltdown