$id

[Anon]

Hi,

my php script displays my database in a table showing all columns exept the column which I use to number the database rows. This column is the only unique column and I would like to use it to identify the rows. When I select one row, $id has the value of the first column which is displayed. How can I assign the value of the "number-column" to this parameter when calling another php script?

Thanks!

Gruss,
Elke

[Anon]

Just to clarify things for me: the rows contain links (the bits you're selecting) and you want the link to take the user to another page, carrying the value of $id with it somewhere?

If that's the case, then you can embed the number in the URL as part of a querystring, along the lines of:

<a href="otherpage.php?number=<?php echo $id?>">This is the bit you select</a>

On otherpage.php the number will be in the variable $number (or $HTTP_GET_VARS['number'] for that matter).

Obviously, you'd actually name the query variable something more useful, and if $id is anything fancier than just a number it may pay to urlencode() it before echoing it.

And of course you can pass multiple variables this way (see http://www.phpbuilder.com/forum/read.php3?num=2&id=170464&loc=0&thread=170464 for an example of how to do this).

Apologies if you know all this and I'm off on a wild and irrelevant tangent.

[subrata]

hi
you can pass the variable in the query string of the hyper link you are using,
<a href="yourscript.php?yourid=<?php echo $yourvariable ?>"> =<?php echo $yourvariable ?> </a>.

hope this wil solve the problem.

regards
subrata