[Resolved] Query results coming up short... (?)

Rodney_H_

Hi, I just noticed that my queries are coming up one short. Can someone help me figure out why? I say I would like to limit the query to ten results, but I only get nine (9) returned.

Here is the code:


<p>These are the 25 all-time great books on golf. Click the links below to read their reviews:</p>
<ul>   

<?php
if(!isset($start)) $start = 0;
// DB conn info
require ("../inc/db.inc.php");  

// "connecting2_db()" function on db.inc.php		
$my_db = connecting2_db(); 
// Select proper table, limit 10.
$sql = "SELECT id,title FROM books ORDER BY id ASC LIMIT " . $start . ", 10";
// Connect or die and tell us
$result = mysql_query($sql,$my_db) or db_mysql_die();
$row = mysql_fetch_array($result);
// While our query is true, do this:
while ($row = mysql_fetch_array($result)){
$id = $row["id"];
$title = $row["title"];
echo "<li><a href='details.php?id=$id'>$title</a></li>\n";
}
?>

</ul>

<br>

<p><?php
$query = "SELECT count(*) as count FROM books";
$result = mysql_query($query,$my_db);
$row = mysql_fetch_array($result);
$numrows = $row['count'];

if($start > 0)
echo "<img src='../images/sitenav/black_arrow_left.gif' alt='Previous' width='6' height='12' border='0'> <a href='" . $PHP_SELF . "?start=" . ($start - 10) . "'>Previous</a>&nbsp;\n";

if($numrows > ($start + 10))
echo "&nbsp;<a href='" . $PHP_SELF . "?start=" . ($start + 10) . "'>Next</a> <img src='../images/sitenav/black_arrow.gif' alt='Next' width='6' height='12' border='0'>\n";
mysql_close(); // end SQL session
?></p>

frikikip

Hi Rodney.

Before you enter your while loop you already fetch a row. This sets the rowcounter on 1, leaving only 9 rows to loop. That's why you are getting the 9 results.

So remove the

$row = mysql_fetch_array($result);

before the while loop and you wil get your 10 result. If you do need the information set in the first row, you can also reset the rowcounter with the php function mysql_data_seek. I dont think that is necessary however.

Hope this helped,

Greets,

Marvin

Rodney_H_

Marvin:

That did the trick. And thanks for explaining to me what I did wrong.

Take care. 😃 😃 😃 😃