[RESOLVED] php keeps putting multi entry into mysql table Help?

[White_Devil]

Ok. I am using this code below. On the message table it puts it in there twice, Sent message twice and notifications table 3 times. It only fires the java once per user but multi times into the table under each user. Please help its driving me nuts.

the dasendto varible is an array passed from the previous page.

$snacks = $_POST;
$dasendto = strip_tags($snacks['to_users']);
$damailsubject = strip_tags($snacks['mailsubject']);    

$dasendmessage = $snacks['sendmessage'];    




// ok lets check the person being logged in.
if ($loggedin == "") {
	echo "Your Not Logged In";
	exit;
}

if ($dasendto == "") {
	echo "You didn't select a member to send to.";
	exit;
}

//if ($dasendmessage == "") {
//	echo "You must put a message in to send to.";
//	exit;
//}

$dasendtolen = strlen($string)-1;
$dasendto = substr($dasendto, 0, $dasendtolen);
$pieces = explode(",", $dasendto);
$dasendmessage = mysql_real_escape_string($dasendmessage);   

print_r($pieces);

foreach($pieces as $key => $value) {
$dasendid = $pieces[$key];  

		   $result = mysql_query("SELECT * FROM profiles WHERE id='$dasendid'");
			while($row = mysql_fetch_array($result)) {
			$isstilluser = $row['id'];
			}	
				if ($isstilluser == "") {
					echo "User id $dasendid is not a member"; 
					exit;
				}
					$cooltime = time();  

					if ($damailsubject == "") {$damailsubject = "No Subject";}
					mysql_query("INSERT INTO message (id, userid, fromid, rawtime, subject, message) VALUES ('', '$dasendid', '$loggedin', '$cooltime', '$damailsubject', '$dasendmessage')");
					mysql_query("INSERT INTO sentmessage (id, userid, fromid, rawtime, subject, message) VALUES ('', '$dasendid', '$loggedin', '$cooltime', '$damailsubject', '$dasendmessage')");
						$result2 = mysql_query("SELECT * FROM message WHERE userid='$dasendid' AND fromid='$loggedin' AND message='$dasendmessage' AND rawtime='$cooltime'");
						while($row2 = mysql_fetch_array($result2)) {
						$danoteid = $row2['id'];
						}
							mysql_query("INSERT INTO notifications (id, rawtime, userid, notifytype, fromuserid, mailid) VALUES ('', '$cooltime', '$dasendid', 'message', '$loggedin', '$danoteid')");  






	 ?>
  <script type="text/javascript">
  $('#writemaildiv').html(''); 
		  alert('Message was sent to the member <?php echo $dasendid; ?>!');
  </script>

<?php 



}

[dagon]

its either due to the previous while() or foreach() its in the loop so inserts as many times as the loop runs

[samcore]

The first decision you need to make is whether you need a graphics card for handling 3D images or whether you are simply requiring 2D image rendering. For 2D requirements, you need only a low-cost solution. In many cases, an integrated graphics solution will suffice for 2D applications. article submitter software

[samcore]

The first decision you need to make is whether you need a graphics card for handling 3D images or whether you are simply requiring 2D image rendering. For 2D requirements, you need only a low-cost solution. In many cases, an integrated graphics solution will suffice for 2D applications. article submitter software

[White_Devil]

i guess i dont understand . this is the whole code except when it opens the database. this is the only foreach loop there is.

[White_Devil]

Fixed on my own. Wasnt the problem with the php . seems i had the java script submit it twice for some reason. lol. Thanks anyways all