Re: [PHP-DB] Navigation Help

2008-06-04 Thread Chris
> $result = safe_query("select count(*) FROM gig g, venue v WHERE g.gigName > LIKE '%".$gig_name."%' "); > $noEntries = mysql_num_rows($result); > $noPages = ceil($noEntries / $limit); $noEntries is always going to be 1 - there is a single row with the 'count' in it. What you probably want i

[PHP-DB] Navigation Help

2008-06-04 Thread Nasreen Laghari
Hi, Could any one please help me with Page Navigation. I have done Next and Previous page Navigation but confused on printing page numbers (1,2,3,4) and hyperlink them. Below is the code which i'm halfway on but it only prints "1" with no hyperlink where as I have 11 pages, if i print $noPages.

Re: [PHP-DB] navigation...

2001-10-03 Thread Russ Michell
Hi there deco: I'm trying to do the same thing myself (Indent posts for a message forum) Here is something I pulled off phpbuilder yesterday: " Generally speaking, threading is evil. Nevertheless, I'll tell you how to do it. Store the comments in a table. Each comment should have a unique ID.

[PHP-DB] navigation...

2001-10-01 Thread deco
I'm trying to solve a problem... I have a site divided in areas. Each area has it's own id, and may have it's own sub-areas. Each sub-area has it's own sub-areas, etc... My will is to return the areas in some cascade order... I can do it recursively, but it generates too many queries. I