Jump to content


Photo

problem


  • Please log in to reply
3 replies to this topic

#1 BillyBoB

BillyBoB
  • Members
  • PipPipPip
  • Advanced Member
  • 630 posts

Posted 15 July 2006 - 07:31 PM

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

heres the 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!");
   }
?> 

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

#2 kenrbnsn

kenrbnsn
  • Staff Alumni
  • Advanced Member
  • 8,235 posts
  • LocationHillsborough, NJ, USA

Posted 15 July 2006 - 07:42 PM

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

Ken

#3 gewthen

gewthen
  • Members
  • PipPip
  • Member
  • 11 posts

Posted 15 July 2006 - 11:47 PM

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

#4 BillyBoB

BillyBoB
  • Members
  • PipPipPip
  • Advanced Member
  • 630 posts

Posted 16 July 2006 - 12:25 AM

thats why i used the first ex




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users