On Sun, Nov 16, 2008 at 12:34 AM, cm_gui <[EMAIL PROTECTED]> wrote: > > Dear Sal > > Can you explain why you disagree ? > > In Mysql, you just need two lines to find the total number of records > in a table: > $query = mysql_query("SELECT * FROM student"); > $number=mysql_num_rows($query);
And that is a REALLY bad way of doing it! "SELECT COUNT(*) FROM student" is much better. > > Thank you. > > G > > On Nov 14, 2:13 pm, Sal <[EMAIL PROTECTED]> wrote: >> I would have to disagree on this. >> >> On Nov 10, 1:56 pm, cm_gui <[EMAIL PROTECTED]> wrote: >> >> > Storing and maintaining a counter for thetotal >> > no. ofrecordsis just too much for such a simple task. >> >> > Can somebody advise? >> >> > Thank you. > > > -- Barry - www.nearby.org.uk - www.geograph.org.uk - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to google-appengine@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~----------~----~----~----~------~----~------~--~---