problem

[BillyBoB]

i didnt want to post here cuz everyone hates me but i cant find how to fix it

heres the code

[code]
<?php
  ob_start();
  $conn = mysql_connect("localhost","user","pass");
  mysql_select_db(database) or die(mysql_error());
  $logged = MYSQL_QUERY("SELECT * from users WHERE id='$_COOKIE[id]' AND password = '$_COOKIE[pass]'");
  $logged = mysql_fetch_array($logged);
  $fffquery = mysql_query("SELECT * FROM profile WHERE ip='$_SERVER['REMOTE_ADDR']'") or die(mysql_error());// this is line 7
  $coninfo = mysql_fetch_array($fffquery);
  if($coninfo[banned]=="yes")
  {
echo("You are banned!");
  }
?>
[/code]

heres the error:


Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/dreamsh/public_html/config.php on line 7

[kenrbnsn]

Change the line in question to either
[code]<?php $fffquery = mysql_query("SELECT * FROM profile WHERE ip='{$_SERVER['REMOTE_ADDR']}'") or die(mysql_error()); ?>[/code]
or
[code]<?php $fffquery = mysql_query("SELECT * FROM profile WHERE ip='" . $_SERVER['REMOTE_ADDR'] . "'") or die(mysql_error()); ?>[/code]

Ken

[gewthen]

Ask the post above illustrated, you cannot include arrays in double quotes and have it resolve to its proper value.

[BillyBoB]

thats why i used the first ex