Help on query required

[lukep11a]

Hi, I am trying to write a query which will bring back entries associated to the user that has logged in, below is the code that I have to call the row with the users info in but so far it's not working.

 

<?php

	$query = "SELECT * FROM selections WHERE username = '$_SESSION['username']'";
	$result = mysql_query($query);

	while($row = mysql_fetch_assoc($result))
	{
?>

 

Any help would be very much appreciated.

 

Thanks

Luke

[fugix]

use the complex syntax on your session inside of you query, also, add some debugging just in case that fails

<?php

	$query = "SELECT * FROM selections WHERE username = '{$_SESSION['username']}'";
	$result = mysql_query($query) or die(mysql_error());

	while($row = mysql_fetch_assoc($result))
	{
?>

[lukep11a]

Thankyou for your quick response, I have made those changes but am now getting a syntax error:

Parse error: syntax error, unexpected $end in /home/content/65/7684865/html/member-home.php on line 124

 

line 124 is the very last line of code, any ideas why it may be doing this?

[fugix]

the error isn't caused by the code that I provided, most likely your are missing a closing curly bracket somewhere. If you cant figure it out post your code and I will look at it

[lukep11a]

Thankyou you were right I was missing the closing bracket!! Thanks for your help it works fine now