MySQL query changes depending on $_GET

[fjm]

Hi all. I have what is to me, a challanging question that I am totally lost on.

I have a form that contains multiple records from a db. I have an edit button that is just sitting there. I want to use this edit button to edit a record in the db but I can't for the life of me figure out how I am going to tie a particular record to this floating edit button.

I suppose if I had to diagram it for clarity I would do something like this:

customer:
1
2
3
4
5

That would be in a dropdown box. The user selects the customer number and the form posts to itself and populates the form with that customers data. The url would look something like:

?id=3&dk=34

I suppose what I need is a way to use that string using the $_GET method for my update sql. I know how to use $_GET but since the dropdown is dynamic the above url will change as the user changes the customer. I need to assign the posted values to the edit button to edit the proper record.

I'm sorry if I am not making much sense here. Can somebody please give me a hand?

Thanks,

Frank

[Weisbartb]

If I am understanding you correctly, simply set the option value to the ID of the row. For instance if the rowid is 10

<option value="10">Whatever text you want</option>
 

On the receiving end of the script

[php]
<?php
$id = $_GET['fieldname'];
$sql = 'UPDATE your_table WHERE id='.$id.' SET do=update';
mysql_query($sql);
?>
[/php]
If this isn't what you are looking for can you please provide some additional information about what you are doing.
~
Brian W.

[fjm]

If I am understanding you correctly, simply set the option value to the ID of the row. For instance if the rowid is 10

<option value="10">Whatever text you want</option>
 

On the receiving end of the script

[php]
<?php
$id = $_GET['fieldname'];
$sql = 'UPDATE your_table WHERE id='.$id.' SET do=update';
mysql_query($sql);
?>
[/php]
If this isn't what you are looking for can you please provide some additional information about what you are doing.
~
Brian W.

Hi Brian,

Thanks for the reply. What you have provided is exactly what I was wanting to do. I was playing around with my script and came to the same conclusion and wanted to post back.

I'm sorry that I am not clear sometimes as to what I need. I am a nubie. :)

Thanks again,

Frank

[Weisbartb]

Glad I could be of help.
~
Brian W.