title: PHP/MYSQL Update only first row with defined value
body: <p>I want to update my database using constraints</p>
  
  <pre><code>for ($count = 0; $count &lt;= $size; $count++) {
  if($dayOfTheWeek[$count] == "Friday" or $dayOfTheWeek[$count] == "Saturday"){
  
  $query = "UPDATE rota SET title='Guest' WHERE date = '$dateMonthYearArr[$count]' AND starttime = '22:00'";               
  $dayresult = mysql_query($query);}
  }
  </code></pre>
  
  <p>I have multiple users with a <code>$starttime</code> of 22:00, but i only want the first users detail to be updated leaving the rest unchanged. how would i go about doing this?</p>