Jump to content


Photo

Database will not update?


  • Please log in to reply
1 reply to this topic

#1 crzyman

crzyman
  • Members
  • PipPip
  • Member
  • 25 posts

Posted 15 September 2006 - 11:23 PM

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?
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')");
   
}



#2 Caesar

Caesar
  • Members
  • PipPipPip
  • Advanced Member
  • 1,025 posts

Posted 16 September 2006 - 12:58 AM

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

Try:
<?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]'");

?>

PHP Ninja




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users