[SOLVED] Parse Error: Unexpected '{'

[waiwai933]

Hi. I'm experiencing some problems with the following code, which is outputting a "Parse error: syntax error, unexpected '{' in /blablabla/example.php on line 13"

 

<?php include("../example.org/header.html"); ?>
    <h1 align="left"> Main Content </h1>
    <p align="left"><?php
$hostname = "databases.example.org";
$username = "bluefire";
$password = "jellybird";
$database = "admin"; 
$link = mysql_connect($hostname,$username,$password);
mysql_select_db($database) or die("Unable to select database");
$query = "SELECT username FROM authentication WHERE authorized is (1)";
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)
{ echo $row['value']; }
?>
<?php include("../example.org/footer.html"); ?>

 

I have, of course changed some of the authentication details to prevent hacking.

 

[AndyB]

while ($row = mysql_fetch_assoc($result)

 

s/b

 

while ($row = mysql_fetch_assoc($result))

[waiwai933]

Aah, an overlooked parentheses. I think I need glasses.

 

New problem. I fixed that, but now there's a

 

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /blablabla/example.php on line 12

 

 

[Mchl]

SELECT username FROM authentication WHERE authorized is (1)

 

Never seen syntax like this before... shouldn''t it be

 

SELECT username FROM authentication WHERE authorized = 1

 

[edit]

 

According to manual it should be

 

SELECT username FROM authentication WHERE authorized is TRUE

[waiwai933]

Nope, none of that works.

 

EDIT: Nevermind, I solved the problem. It turns out that I had entered the wrong table name.