My script or my host's Problem?

[manipura]

When I run this script on f2s.com it doesn't work, I have been up all night and wondering if I'm dumb or my host is dumb. All the database stuff works fine, just no script I can run on the site connecting to the DB will work.

I haven't programmed in PHP for awhile so I'm wondering if its me or not.

<?php
//connection to the db
$host="db.nanaimo-online.f2s.com:3306";
$user="user";
$pass="pass";
$db="db";

$conn = @mysql_connect("$host", "$user", "$pass");
    if (!$conn) {
    print ("<p>Unable to make a connection to the server at this time.</p>");
    exit();
    }
    
mysql_select_db("$db");
    if (! @mysql_select_db("$db")) {
    print ("<p>Unable to connect to the database at this time.</p>");
    exit();
    }
// connection is made


$sql = "select * from calgary";
$result = "mysql_query($sql);

while($row = mysql_fetch_array($result)){

$id = $row["id"];

echo "$id";
}

?>

I get an error saying
Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in /web/sites/221/nanaimo/www.nanaimo-online.f2s.com/testcalgary.php on line 28


Line 28 = $id = $row["id"];

There is a field in the table that is named "id". Now I just don't know whats wrong!

[tubedogg]

Try changing line 28 to
$id = $row[id];

For whatever reason I have never been able to get a script to work with
$row["colname"]
I have always had to use
$row[colname]

[Anarchos]

Using quotes is fine and is the correct way of accessing associative arrays. The real problem is this line:

$result = "mysql_query($sql);

[manipura]

$row["colname"]
has always worked for me.
Same with
echo "$input";
But that didn't work on f2s.com either.

I have
echo ($input);
now...

Now my problem is................
The last line of the script.

It says
Parse error: parse error in /web/sites/221/nanaimo/www.nanaimo-online.f2s.com/testcalgary.php on line 33

Line 33 is where the "?>" is...........
I tried "PHP?>"
but ther didn't work either

[Anarchos]

Can you post the code again?

[manipura]

All is well...

Thank you very much guys!

[Defender1]

<?
mysql_select_db("$db");
    if (! @mysql_select_db("$db")) {
    print ("<p>Unable to connect to the database at this time.</p>");
    exit();
    }
// connection is made


$sql = "select * from calgary";
$result = "mysql_query($sql);

while($row = mysql_fetch_array($result)){

$id = $row["id"];

echo "$id";
}

?>

He either forgot to take out that last }, or he forgot to put a } else { in there.

[Anarchos]

The last } closes the while loop.