Reading tags in mysql from [comments_all]

[Herbert]

Hello,
I use demo.mysql.php to put everthing in MySQL
How can i read the year (s:4:"year";a:1:{i:0;s:4:"2014";) in field [comments_all] with a external script?
Can someone give me a example?

Many thanks..

[James Heinrich]

Code: Select all

$sql = 'SELECT `comments_all` WHERE (`filename` = "'.mysql_real_escape_string($filename).'")';
$result = mysql_query($SQLquery);
if ($row = mysql_fetch_assoc($result)) {
  if ($comments_all = @unserialize($row['comments_all']))) {
    $year = $comments_all['year'][0];
  }
}

[Herbert]

Thank u verry much James!