[SOLVED] unexpected T_VARIABLE

[cs1h]

Hi,

 

I have a short bit of code which keeps coming up with the error,

Parse error: syntax error, unexpected T_VARIABLE in D:\Inetpub\vhosts\mjfdskkoho.com\httpdocs\test_form_check.php on line 10

 

The code is

<?php 
if(isset($_COOKIE['loggedin']))
{
include (config.php);

$username = ($_COOKIE[loggedin]);

mysql_connect($server, $db_user, $db_pass) or die (mysql_error()); 

$result = mysql_db_query($database, 'select * from ac_users WHERE username = '$username'') or die (mysql_error()); 

   while ($qry = mysql_fetch_array($result)) { 
      echo '$qry[name1]'; 
   } 


?>

 

Can anyone help?

 

All help is much appreciated,

 

Cheers

Colin

[beansandsausages]

Try :

 

<?php 
if(isset($_COOKIE['loggedin']))
{
include (config.php);

$username = ($_COOKIE[loggedin]);

mysql_connect($server, $db_user, $db_pass) or die (mysql_error()); 

$result = mysql_db_query($database, 'select * from ac_users WHERE username = '$username'') or die (mysql_error()); 

   while ($qry = mysql_fetch_array($result)) { 
      echo '$qry[name1]'; 
   } 

}
?>

[pdkv2]

You have an error in sql query

 

'select * from ac_users WHERE username = '$username''

 

change this to

 

 

"select * from ac_users WHERE username = '". $username ."'"

 

 

Cheers !

[Cep]

You probably want to interpolate, not concatenate

 

"SELECT * FROM ac_users WHERE username = {$username}";

[beansandsausages]

You have an error in sql query

 

'select * from ac_users WHERE username = '$username''

 

change this to

 

 

"select * from ac_users WHERE username = '". $username ."'"

 

 

Cheers !

 

the error T_VARIABLE mean missed } some were off the script some were, he started the scrpt with a if statment :

<?php 
if(isset($_COOKIE['loggedin']))
{
include (config.php);

and he never closed the statment with a  }

[Cep]

Gah, time limit seems to be reduced to several seconds so,

 

"SELECT * FROM ac_users WHERE username = '{$username}'";

 

Forgot to place the single quotes for an obvious string

[pdkv2]

hi cs1h have you tried all these ?

 

[cs1h]

Hi,

 

Thanks for the replies, its working know,

 

The new code is

<?php 
if(isset($_COOKIE['loggedin']))
{
include ('config.php');

$username = ($_COOKIE[loggedin]);

mysql_connect($server, $db_user, $db_pass) or die (mysql_error()); 

$result = mysql_db_query($database, "select * from ac_users WHERE username = '$username'") or die (mysql_error()); 

   while ($qry = mysql_fetch_array($result)) { 
   $name = $qry['name1'];
   $horde = $qry['horde'];
      echo $name; 
   } 

}
?>

 

Cheers

Colin

[pdkv2]

Okey

 

thats good !

 

Cheers

[beansandsausages]

No problem i was right for a change