Re: [PHP] return the amount of records in a mysql databace

2002-09-22 Thread Philip J. Newman
t; ---John Holmes... > > > -Original Message- > > From: Jeff Bluemel [mailto:[EMAIL PROTECTED]] > > Sent: Sunday, September 22, 2002 11:46 AM > > To: [EMAIL PROTECTED] > > Subject: Re: [PHP] return the amount of records in a mysql databace > > > >

RE: [PHP] return the amount of records in a mysql databace

2002-09-22 Thread John Holmes
[EMAIL PROTECTED]] > Sent: Sunday, September 22, 2002 11:46 AM > To: [EMAIL PROTECTED] > Subject: Re: [PHP] return the amount of records in a mysql databace > > this is only going to return records in a table, and not in a database > > > > select count(*) as n from ... where

Re: [PHP] return the amount of records in a mysql databace

2002-09-22 Thread Philip J. Newman
, September 23, 2002 1:28 AM Subject: RE: [PHP] return the amount of records in a mysql databace > select count(*) as n from ... where ... > > -Original Message- > From: Philip J. Newman [mailto:[EMAIL PROTECTED]] > > Can someone point me in the right direction to find

Re: [PHP] return the amount of records in a mysql databace

2002-09-22 Thread Chris Shiflett
Look through the MySQL functions. I seem to recall that there is a function for just about anything, and all you really want to do is find how many rows are in all the tables in a particular database. Thus, a couple of loops is all you need, with the outer one looping through each table (obtai

Re: [PHP] return the amount of records in a mysql databace

2002-09-22 Thread Jeff Bluemel
this is only going to return records in a table, and not in a database > select count(*) as n from ... where ... > > -Original Message- > From: Philip J. Newman [mailto:[EMAIL PROTECTED]] > > Can someone point me in the right direction to find out how i can return the > amount of records

RE: [PHP] return the amount of records in a mysql databace

2002-09-22 Thread Mark Charette
select count(*) as n from ... where ... -Original Message- From: Philip J. Newman [mailto:[EMAIL PROTECTED]] Can someone point me in the right direction to find out how i can return the amount of records in a mysql databace ? -- PHP General Mailing List (http://www.php.net/) To unsubs