getting a list of updated mysql tables

[envexlabs]

Hey,

 

the mysql forums are dead, so i thought i'd give here a shot

 

Is it possible to check and see if any mysql tables have been updated.

 

ie. if a store has added new products, etc.

 

Thanks,

 

envex

[colombian]

If you are trying to know if it has been updated after running a query, then do:

<?php 
$query = "UPDATE table SET ....";
$result = mysql_query($query);
if (mysql_affected_rows() > 0) { 
   // a row was updated, so do what you need
   // mysql_affected_rows() is probably what you are looking for.
}
?>

[envexlabs]

Hey,

 

I'm not to sure if this is what i'm looking for.

 

What i have is a page that renders out all the stores a user has added as favorite.

 

I want to show, if applicable, if a store has updated any of their information.

[liebs19]

For that you will probably need to store the date and time that they last updated their information in the database. Also store the last login time for the user in the database. Then just compare the last information update time to the last login time for the user.