session variable in WHERE clause

[Bazzaah]

I'd appreciate some help please.

 

I'm using $_SESSION to pass info from a MySQL search to a new page.

 

How do I include the $_SESSION in the SELECT? I've done loads of different combinations - none has worked and I've not found anything to help on Google.

 

In this case;

 

user searches a db table.

Results are returned.

User can click on result to be taken to a new page where columns from the row are displayed

 

Results are displayed on the new page like this;

 

$query = "SELECT * FROM table";  

$result = mysql_query($query) or die(mysql_error());

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

echo $_SESSION[$column] ;

}

 

That code returns the correct column BUT for as many rows there are in the table.

 

How can I  set things up so that column entries are only echoed for the one row that's been selected by the user?

 

Sorry if unclear; happy to clarify if needed - any help would be really appreciated.

[WebStyles]

do you mean this: (?)

session_start();
$col = $_SESSION[$column];
$query = "SELECT $col FROM table";  
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_assoc($result)){
    echo $row[$col] ;
}

[voip03]

I think Pagination will help you

 

http://www.phpfreaks.com/tutorial/basic-pagination

[Bazzaah]

Thanks both of you.

 

I'll read through the pagination tutorial.

 

Re the code WebStyles, I've not made that work yet. Is there not just a way that I can use a WHERE clause in the SELECT?