[RESOLVED] syntax error, unexpected T_IF

nymall

Hey guys, the error I'm getting is Parse error: syntax error, unexpected T_IF in /home/nfagerlid/dkindustrial.net/prealpha/status.php on line 3. I've scowered the first part of this code, and I've implemented it exactly as the book has it, but I can't for the life of me figure out what I'm doing wrong. here's the source:

<?php
	session_start()
	if ( $_SESSION['login'] != 1 ) 
	{
		header("Location: login.php");
		exit();
	}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<?php
	$host="???";
	$user="???";
	$password="???";
	$dbname="bgreg";
	$cxn=mysqli_connect($host, $user, $password, $dbname) or die ("Woah... where'd it go?");
	$query="SELECT gmtbl WHERE UID='$_SESSION['id']'";
	$result=mysqli_query($cxn, $query) or die ("Couldn't communicate");
	$row=mysqli_fetch_assoc($result);
	?>
<body>
<p>Name:<?php echo "$row['name'] ?><br />
Budget:<?php echo "$row['budget'] ?><br />
Percent done:<?php echo "$row['percent'] ?><br />
Number of workers:<?php echo "$row['workers'] ?><br />
Project Type:<?php echo "$row['project'] ?></p>
</body>
</html>

Thank you in advance!

nymall

Well, never mind... I solved the first error... I forgot a semi-colon. However, it revealed a deeper layer of error...

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/nfagerlid/dkindustrial.net/prealpha/status.php on line 21...

Fixed that... Sorry for the trouble... Need to step away for a few moments to let the eyes relax.

halojoy

    $query="SELECT gmtbl WHERE UID='$_SESSION['id']'";

If UID is a numeric, integer field, you should not have quotes around the value
UID = $_SESSION['id']
Also when using indexed array inside "SELECT double quoted string"
you should add {curly braces} around

So, my guess is this would be right for your query. (UID is INTEGER)

    $query="SELECT gmtbl WHERE UID = {$_SESSION['id']} ";

But if your UID is a VARCHAR or TEXT field:

    $query="SELECT gmtbl WHERE UID = '{$_SESSION['id']}' ";