counting records

[jarv]

hi, I would like to display a number next to each of my books ie:

 

Book Title 1: Mr. Tickle
Book Title 2: Mr. Greedy
Book Title 3: Mr. Topsy-Turvy
Book Title 4: Little Miss Bossy
Book Title 5: Mr. Uppity

 

 

but instead (as they are being output as an array) I get:

 

Book Title 0: Mr. Tickle
Book Title 1: Mr. Greedy
Book Title 2: Mr. Topsy-Turvy
Book Title 3: Little Miss Bossy
Book Title 4: Mr. Uppity

 

 

here is my code

$pagecount=0;
$qry="SELECT BookID,BookTitle,BookInfo FROM mrmen";
$cur=mysql_query($qry);
if(!$cur){
    echo $cur.'<br />'.mysql_error();
}
while($i=mysql_fetch_row($cur))
{$BookID[$pagecount]=$i[0];
$BookTitle[$pagecount]=$i[1];
$BookInfo[$pagecount]=$i[2];
$pagecount++;
}


for ($i=0;$i<$pagecount;$i++){
    echo 'Book Title '.$i.': '.$BookTitle[$i].'<br />';
}      

[davidannis]

change

    echo 'Book Title '.$i.': '.$BookTitle[$i].'<br />';

to

    echo 'Book Title '.($i+1).': '.$BookTitle[$i].'<br />';

Edited June 6, 2013 by davidannis

[jarv]

I have tried this and I get:

 

[06-Jun-2013 15:39:58] PHP Parse error:  syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ',' or ';' in /Applications/MAMP/htdocs/mrmen/index.php on line 11
 

[Zane]

use $i++ instead of $i+1

[jarv]

I have tried this and it just displays 0, 2, 4

[TOA]

for ($i=0;$i<$pagecount;$i++){

    $n = $i+1;

    echo 'Book Title '.$n.': '.$BookTitle[$i].'<br />';

} 

 

[davidannis]

jarv, you need the parentheses around ($i+1). I edited the post but not before you saw it. or TOA's solution will work.