passing an ID field through to PHP

[Colm Osiris]

I think this is a PHP question, and not MySQL?

I have a MySQL database which I'm searching via PHP, and it produces a list perfectly well.

I want to be able to click on a button on any of the found records in the list, to go to a detail page for that record.

I have a problem:

The ID field I'm passing as a hidden field is always from the last record in the list, regardless of which record's button I click. I imgaine this is because by the time the button is pressed, the ID field has been incremented? But how do I get round it please?

Many thanks in advance. :-)

[scribbz]

If it's just an incrementation problem then it's being incremented too early in your script. Just change it so that incrementation occurs after the 'view detail' button has been generated (and its link obviously). Unless I'm missing something it should be as straightforward as that, but as always it helps to see the portion of your code that's performing this step in your application.

[Colm Osiris]

Thank you very much.

It wasn't exactly an incrementation problem.

I only had one form on the page I was generating, because I didn't realise that you could have more than one.

I've now put in one form per button, so the hidden ID field is different for each one, and it works wonderfully.

Hmmm, now I've got the search producing a list, and a detail page successfully, I need to learn how to update the data, but that's another thread!

Next time I have a question (which won't be very long!), I shall make sure to include the relevant code. :-)