query update

dcjones

Hi all,

Not to sure if this should be in this section or the Database section, so sorry if I have posted it in the wrong section.

I have 2 table which I extract data using the query below. This works fine. What I want to do is run an update query that updates all the record that the original query returned.

My first query.

SELECT 
members.
member_id, title, name_f, name_l,  company_name, houseno, street, city, state, zip, country, added,  

payments.product_id,  payments.completed,  payments.processed  

FROM members  JOIN  payments  

WHERE  members.member_id = payments.member_id  

AND payments.processed = 0 
AND payments.completed = 1  

AND payments.product_id IN (18,19,20,21,4,5,3)

Is it possible to run a second query that updates the "payments.processed " feild which by default is set to 0, and update all the records in the first result to 1.

All I want to do is update just the one feild and leave the data in all the pther feild intact.

Many thansk if you can advise.

dcjones

Hi all.

I am going to ask the same question another way.

I have a form which displays the results of a database query. The form has 2 feild, "member_id" and "processed". By defualt the processed feild contain "0".

Is there a way that I can change the "0" to a "1" and have it update all the other rows. This maybe a Javascript job, I don't know.

The Form

<form method="post" name="form3" action="<?php echo $editFormAction; ?>">
                <table align="center" cellpadding="0" cellspacing="0" bordercolor="0">
				<tr>
		    <td class="bodytextbold">Update</td>
		    <td></td>
				</tr>
                  <?php do { ?>
				  <tr valign="baseline">
                      <td width="134" class="bodytext"><?php echo $row_process['member_id']; ?></td>
                      <td width="134" class="bodytext"></td>
                      <td width="96"><input name="processed" type="text" class="bodytextsmall" value="<?php echo $row_process['processed']; ?>" size="3" /></td>
                      </tr><?php } while ($row_process = mysql_fetch_assoc($process)); ?>
                  <tr valign="baseline">
                    <td></td>
                    <td></td>
                    <td><input name="submit" type="submit" value="U" /></td>
                  </tr>
                </table>
                <input type="hidden" name="MM_update" value="form3">
                <input type="hidden" name="member_id" value="<?php echo $row_process['member_id']; ?>">
              </form>

Any ideas as to how I can do this. many thanks again.