First Record ....

[Anon]

When a mySQL query is executed it doesn't display the first record in my php-file...

How is this possible?
And what can I do about it?

Kind Regards
Maarten Elsenaar

[tomhath]

"How is this possible?"

Probably something wrong with your code.

"And what can I do about it?"

Post the code, maybe someone can help yopu with it. As it is,we have no information.

[Anon]

Here's my code:

<?

$limit=10;
$numresults=mysql_query("SELECT prod_id, prod_name, prod_description_small FROM store_products WHERE prod_category='$prod_cat' order by prod_name");
$numrows=mysql_num_rows($numresults);

if (empty($offset)) {
$offset=1;
}

$result = mysql_query("SELECT prod_id, prod_name, prod_description_small FROM store_products WHERE prod_category='$prod_cat' order by prod_name limit $offset,$limit");

?>
<table border=0 width="80%" bordercolor="#000000" align="center" class="tekst">
<tr align="left">
<td width="180" class="subkop">Produkt</td>
<td width="324" class="subkop">Omschrijving</td>
<td width="132" class="subkop">Actie</td>
</tr>
<?
while ( $data = mysql_fetch_array($result) ) {
echo("<TR>\n");
$prod_id = $data["prod_id"];
$prod_naam = $data["prod_name"];
$omschrijving = $data["prod_description_small"];
echo("<TD class='text'>$prod_naam</TD>\n");
echo("<TD class='text'>$omschrijving</TD>\n");
echo("<TD><A HREF='prodviewer.php?prodid=$prod_id'><font class='text'><b>meer info</b></font></A></TD>\n");
echo("</TR>\n");
}

?>
</table>

[tomhath]

Are you sure you want to start at OFFSET 1? I don't see where you set $offset to anything other than 1 (was it ever initialized?)

This is what the mysql manual says:

"LIMIT takes one or two numeric arguments. If two arguments are given, the first specifies the offset of the first row to return, the second specifies the maximum number of rows to return. The offset of the initial row is 0 (not 1)"

[Anon]

Well, it does.

The page displays a whole database table whit ten records per page.

So the offset starts at one, and for the next page it goes to offset is 10.

But when I start my variable offset with 0 it does display my first record.

So the problem is fixed!

Thanks for your attention to the LIMIT function it does make a little bit more sense now...

Greetings
Maarten