update question

slimjim

Ok here is my query :

$query = "update members_credits set credits_num=credits_num+$credits";

Now With that I am updating all members credits at once.
Now my question is this.
How can i get the User_id from each of those members I just updated ?
In the table members_credits there is a field called User_id

Reason is this : I need the user_id of those members i just updated so that i can insert a new row into another table at same time.

Now really sure how to do this.

travelbuff

If you are updating all records, as in your example, you just need to select all of the ids:

$query = "select members_id from members_credits";

If you use a conditional, the same conditional should reselect the same members, unless it is based on credits. If so, run the select statement first and then update the credits.

BTW, I am not sure if your query will work:
$query = "update members_credits set credits_num=credits_num+$credits";

You may have to change the credit value outside the query.
$credits_num = ($credits_num + $credits);

slimjim

Ok that didn't work. Updating credits works fine. Inserting the insert isn't working at all when using all, but other insert works when i only update one member. Here is code:

if($submit == "Add"){

	if($creditsadd=="all"){

	   Print $query = "update members_credits set credits_num=credits_num+$credits";

//Below If Statement isn't working right, It isn't putting a row in for each member and it isnt
//putting in the userid
		if ($sendtoinbox) q("INSERT INTO event (`id`, `sender`, `title`, `contents`, `type`, `user_id`, `credits`, `status`, `rdate`) VALUES ('', 'admin', 'Admin Updated your Credits', 'Your Credits have been Updated', 'news', '$user_id', '0', '1','".strtotime(date("d M Y H:i:s"))."')");

	}else{
		$query3 = "update members_credits set credits_num=credits_num+$credits where user_id=$creditsadd";
	}
	mysql_query($query3) or die( "ERROR: " . mysql_error() . "\n");		
//Below if statement is working just fine	        

		if ($sendtoinbox) q("INSERT INTO event (`id`, `sender`, `title`, `contents`, `type`, `user_id`, `credits`, `status`, `rdate`) VALUES ('', 'admin', 'Admin Updated your Credits', 'Your Credits have been Updated', 'news', '$creditsadd', '0', '1','".strtotime(date("d M Y H:i:s"))."')");


	$res="Successfully added credits";

}

Here is code from form :

<SELECT NAME="creditsadd">
				<option value="all" selected>All Active Members 
<?   

			  $r=q("SELECT id, login FROM members where status='1' order by id");
			  while ($nr_row=mysql_fetch_row($r)){				   				   
				 echo "<option value=$nr_row[0]>$nr_row[1]\n";
			  }          			
?>          			

		 </SELECT>

slimjim

Problem I am having is that I cant get the insert to work when I show all in the form. Updating the credits is no problem. Just the insert part is. For some reason it isnt inserting a new row for each member credits i updated.

Any ideas at all ?