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

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.