|
|
Posted by Tyno Gendo on 04/19/07 10:06
Tyno Gendo wrote:
<snip>
>
> $sql = "SELECT cr.catID, cat_title, recipeID, recipe_title
> FROM catrecipe cr, recipe
> WHERE cr.catID = recipe.catID AND cr.catID = " . (int)$cat_id .
> " ORDER BY recipeID DESC LIMIT {$start}, {$end}";
> $ds = mysql_query($sql) or trigger_error("Unable to query database: "
> . mysql_error());
note that my $page var is 0 based. so if you display page to the user,
use $page+1 so it doesn't say 'You are viewing Page 0' :)
Navigation:
[Reply to this message]
|