What am I doing wrong? (mysql_result)

[Kameloh]

A friend of mine helped me script this.. but I don't know what's wrong with mysql_result.

<?php
$link = mysql_connect('localhost', 'blahblah', 'password');
if (!$link) {
   die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';

mysql_select_db('blahblah',$link);

$capturepic = mysql_query("SELECT picid, username, title, comment FROM pictures WHERE postlock=1");

$capturerow = mysql_fetch_array($capturepic);

$total = mysql_num_rows($capturepic);

for($start=$total-15; $start<= $total; $start++) { 

mysql_result($capturepic, $start, "picid");

}
mysql_close($link);
?>

Can anyone please shed some light?

[maxpup979]

well the first thing that comes to mind is: what happens when total is less than 15? That probably will give you some problems.

[kburger]

maxpup979 wrote:

well the first thing that comes to mind is: what happens when total is less than 15? That probably will give you some problems.

... and you're never doing anything with whatever you pull out of the database. Better go back and check the PHP manual. There are lots of examples there that should help.