[RESOLVED] store row cell in a variable

[greedyisg00d]

I have a table which has 2 columns namely firstname and lastname which I fetch from the database and I echo the values using while loop. Now what I want is to add another column which contains a url view which will get the names and display the values to the next page for example.

Lastname | Firstname | View
Walker | John | View
Sam | George | View

Thus when I click view in the first row I must get the lastname walker and firtsname john and store it in a variable.

Any idea on how can this be done? Thanks

[bradgrafelman]

Basic database techniques would suggest you have a column that can uniquely identify each row in the table (for example, an auto increment "id" column).

Having such a column would allow you to link to the next page with a query string such as "view.php?id=3" so that view.php knows which record the user is after.