Mysql Insert Query Locking Becuz It Tries to Select before Read Lock Is Finish

My site is having some problems and getting locked on an insert (cause lock) and then it tries to select b4 read lock is finished causing my script on calendar.php to lock the site up which causes it (during heavy traffic) to just keep reloading without finishing out the whole page.

Here is the exact message my administrator sent me: (t appears that your script is causing contention with the database it is trying to access. You are inserting (causing a lock) ) and then attempting to select, and the read lock isn't complete yet. This is causing the lock contention that your calendar script is suffering from. Please reevaluate your code to streamline your queries and/or change it to atomic writes (by using the lock procedure)

What be the best thing to do at this point?? Because its causing me to miss out on THOUSANDS OF DAILY USERS).

Need help Quick

My site is http://caltweet.com by the way.

thanks

 

You will need to show the code otherwise we cannot help.

 

<?php 
$result = mysql_query("select uid, profile_image_url,screen_name from users order by made desc limit 12");
$num = 0;
while($row = mysql_fetch_array($result)){
	$num++;
	$img = $row['profile_image_url'];
         if($img == "") { $img = "http://static.twitter.com/images/default_profile_normal.png"; }
	$uid = $row['uid'];
	$screen_name = $row['screen_name'];
	echo "<a href=\"./u/$screen_name\"><img  width=\"48px\" height=\"48px\" src=\"$img\"></a>";
	if($num % 4 == 0){ echo "<br>"; }
}
?>
                    </div>
                    </div>
        <div style="float:left;width:100%;">
        <b class="wgb4"></b><b class="wgb3"></b><b class="wgb2"></b><b class="wgb1"></b></b>
	</div>
      </div>
      </div>
    <!--- END RECENT TWEETERS -->
                
                
                <!--- SPOTLIGHT -->
<div style="width:420px;float:left;margin-left:30px;">
      <div style="margin-left:0px;margin-top:0px;float:left;width:100%;">
        <b  class="wgtop"><b class="wgb1"></b><b class="wgb2"></b><b class="wgb3"></b><b class="wgb4"></b></b>
	<div class="blue_box" style="height:200px; width:418px; color:#ffffff; text-align:center;">
                    	<strong>Social Event Sharing</strong>
<ul style="size:8px; color:#000000; text-align:left;">
	<li>Share/Find Events via Twitter, Facebook, Myspace, Email & other social media sites right from Caltweet</li>
<br>
        <li>Caltweet is the fastest, easiest, & safest ways to Promote your events online</li>
<br>
        <li>Print Guestlist & Have RSVP's Emailed Directly to your inbox <a href="http://caltweet.com/create.php">Click Here to Start</a> or <a href="howto.php">Learn How to Use Caltweet</a> </li>
     <!--  <a href="http://caltweet.com/961">
        <img src="http://www.calendartweet.com/imgs/caltweet-charity.jpg" title="Caltweet 4 Charity"  alt="Caltweet 4 Charity"/></a><br /><font color="#000000">Click here:</font> <a href="/961">CalTweet 4 Charity</a><br />-->
         <form style="margin-top: 10px;" action="./allevents.php" method="get">
<input onkeyup="searchEvents();" size="42" autocomplete="off" style="height:9; font-size:12px; padding:0px;" type="search" name="se" id="se" />
<input style="height:9; font-size:12px; padding:0px;" value="Search" type="submit" /><br />
<div style=" z-index:1000; position:absolute; visibility:hidden; text-align:left; margin:0px; padding:0px; width:330px; background-color:#CCCCCC;" name="search" id="search"></div>
</form>
</ul>

                   </div>
        <div style="float:left;width:100%;">
        <b class="wgb4"></b><b class="wgb3"></b><b class="wgb2"></b><b class="wgb1"></b></b>
	</div>
      </div>   	
    </div>   
    <!--- END SPOTLIGHT -->
                
                
                
            </div>
            <div class="right">
                <div class="tags"><div style="height:185px; overflow:hidden;"><img src="/imgs/section_names_03.jpg" />
                
                <?php 
$max = mysql_fetch_array(mysql_query("select max(tag_count) as max from tags"));
$max = $max['max'];
$small = 10;
$large = 25;
$num = 0;
$result = mysql_query("select * from tags order by rand() limit 15");  
while ($tag = mysql_fetch_array($result)){
if($num > 0){ echo ", "; }
$num++;
$tagcount = $tag['tag_count'];
if($tagcount == "" || $tagcount < 1){ $tagcount = 1; }
$percent = $tagcount / $max;
$size = (($large - $small) * $percent) + $small;
echo "<font  size=\"{$size}px\" style=\"font-size: {$size}px;\"><a href=\"/t/". str_replace('+', '-', urlencode($tag['tag'])) . "\">{$tag['tag']}</a></font>";
}
?></div><div style="height:100px; overflow:hidden;">
Follow the Creators:<br />
<a href="http://twitter.com/mrcaltweet"><img src="http://caltweet.com/imgs/freddy.jpg" width="55px" height="55px" /></a> 
<a href="http://twitter.com/michaelrevell"><img src="http://a3.twimg.com/profile_images/457209831/6935_167176678078_697813078_3722745_2905007_n-1_normal.jpg" width="55px" height="55px" /></a>

</div>
                
                </div>
            </div>
        </div>
        <div class="bottom">
        	<!--- RECENT EVENTS -->
<div style="width:860px;float:left;margin-left:18px;">
      <div style="margin-left:0px;margin-top:0px;float:left;width:100%;">
        <b class="retop"><b class="reb1"></b><b class="reb2"></b><b class="reb3"></b><b class="reb4"></b></b>
	<div class="re_box" style="height:120px; width:857px;">
    
    
                	<div class="re_pic"><img src="/imgs/section_names_14.jpg" /></div>
                    <div class="seperator"></div>
                    <?php
$result = mysql_query("select * from events join users on (user_id = uid) where ispublic = 1 order by created desc limit 4");
$i = 0;
while($row = mysql_fetch_array($result)){
$i++;
$event_id = $row['event_id'];
$hex_id = encode_eid($event_id);
$event_time =  date("F j, Y, g:i a", $row['event_time']);
$link = "<a href='http://caltweet.com/$hex_id'>";
$event_title = stripslashes($row['event_title']);
//$event_pic = "<img width='300px' height='300px' src='{$row['event_pic']}'>";
$event_pic = max_picture($row['event_pic'], 120, 90, $event_title);
$event_desc = $row['event_desc'];

Code (markup):