It\'s a script for geeklog. but i want it in a normal php script.
<?php
function phpblock_randomQuote()
{
global $_CONF;
$result = DB_query("
SELECT * FROM quote
ORDER BY RAND()
LIMIT 1
");
$res = DB_fetchArray($result);
$author = ($res[\'author\']) ? $res[\'author\'] : \'anonymous\';
$source = ($res[\'source\']) ? $res[\'source\'] : \'\';
if ($source != \'\' && $res[\'year\'] != \'\') {
$year = ", {$res[\'year\']}";
} else {
$year = \'\';
}
$link = "<a target=\'new\' title=\'$source $year\' href=\'http://www.google.com/search?sourceid=navclient&ie=UTF-8&oe=UTF-8&q="
. $author . "\'>" . $author . "</a>";
$authorLink = ($author != \'anonymous\') ? $link : \'anonymous\';
$retval = <<<EOF
<table>
<tr>
<td>"{$res[\'quote\']}"</td>
</tr>
<tr>
<td align="right">-- <b>$authorLink</b></td>
</tr>
</table>
EOF;
return $retval;
}
?>
[/code]