Parse error

[Anon]

I've been getting the following error:

Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' in /directory/news.php on line 68

So I've narrowed the problem down to somewhere in the following code, but can't figure out for the life of me what's wrong.

<tt>
$permquery = mysql_db_query("database","SELECT DISTINCT game FROM perms WHERE ID=$ID");

while ($row = mysql_fetch_array($permquery))
{
$permresult = mysql_db_query("database","SELECT splat FROM perms WHERE ID=$ID AND game='$row["game"]'");
while ($permrow = mysql_fetch_array($permresult))
{
echo "<option value=\"".$row["game"]."-".$permrow["splat"]."\">".$row["game"]." - ".$permrow["splat"]."</option>";
}
}
</tt>

[[deleted]]

permresult = mysql_db_query("database","SELECT splat FROM perms WHERE ID=$ID AND game='$row["game"]'");

Waaaay too many quotes in there... Why didn't you use the concatenation technique that you use 3 lines further down the script?

[dannys]

Yeah, it should read

$permresult = mysql_db_query("database","SELECT splat FROM perms WHERE ID=$ID AND game='".$row['game']."'");

What's with the mysql_db_query anyhow? most people just open their database at the start of the script and then use mysql_query($query,$link) - the $link is only needed if you have multiple databases open.

Hope this helps.

[Anon]

The new line worked, thanks.

I was having some weird problems a few months back with mysql_query, which went away with mysql_db_query. It's become habit.

[dannys]

Fair enough, though solving problems simply by changing commands can often haunt you later on 🙂