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.