randomise an image sql/database

on my site i use coppermine for my gallery manager. i have wrote a script to get an image from the database and display it on another page in my site (shown below)

how would i go about making this image random?

thanks in advance

[code=php]
<?
$query = ‘SELECT * FROM cpg135_pictures’;
$result = mysql_query($query, $link);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
?>
<img src=”http://www.knowj.com/coppermine/albums/<? echo $row[‘filepath’]; ?>normal_<? echo $row[‘filename’] ?>” width=”350″>
[/code]

Also in #PHP _↴