Database will not update?

[crzyman]

Can someone please tell me what is wrong with this statement? If there are four rows in the database a fifth one will be added, but it will not update. Any ideas?
[code]
if ($num_rows == "5") {

$sql = mysql_query("UPDATE shoutbox SET message='$message', time=now() WHERE artist_name='$artist_name' AND time=(SELECT min(time) FROM shoutbox WHERE artist_name='$artist_name')");

}
else {
  $sql=MYSQL_QUERY("INSERT INTO shoutbox (artist_name,name,message)".
      "VALUES ('$artist_name','$name', '$message')");
 
}

[/code]

[Caesar]

Could be something simple, like how the names that are stored in the db are formatted (Empty spaces, tabs...etc)

Try:
[code]<?php

$query_time = mysql_query("SELECT min(time) FROM shoutbox WHERE trim(artist_name)='$artist_name'");
$thetime = mysql_fetch_array($query_time);

$sql = mysql_query("UPDATE shoutbox SET message='$message', time=now() WHERE trim(artist_name)='$artist_name' && time='$thetime[time]'");

?>[/code]