$dbh->do('CREATE CHART line (Month FLOAT, sales FLOAT)');
$sth = $dbh->prepare('INSERT INTO line VALUES( ?, ?)');
for ($i = -3; $i < 13; $i++) {
$sth->execute(5**$i, exp($i));
}
$rsth = $dbh->prepare(
"SELECT LINEGRAPH FROM line
WHERE WIDTH=450 AND HEIGHT=450 AND X_AXIS='5**X' AND
Y_AXIS='e**X' AND Y_LOG=1 AND X_LOG=1 AND
SHOWVALUES=0 AND TITLE = 'Sample Log-Log Linegraph' AND
COLOR='lred' AND SHOWGRID=1 AND SHOWPOINTS=1");
$rsth->execute;
$rsth->bind_col(1, \$buf);
$rsth->fetch;
</pre>
<img src="imgs/simpylog.png" alt="Log-Log Graph">
<p>
<a name="candlestick"></a>
<h3>Candlestick Chart</h3>