Received: from nextearth.com (ns.nextearth.com [208.245.181.114]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1JLbYx98585 for ; Mon, 19 Feb 2001 16:37:34 -0500 (EST) (envelope-from herbie@nextearth.com) Received: from nextearth.com (208.245.182.73) by nextearth.com with ESMTP (Eudora Internet Mail Server 3.0.1) for ; Mon, 19 Feb 2001 16:45:37 -0500 Message-ID: <3A9192B7.EF0D1A2B@nextearth.com> Date: Mon, 19 Feb 2001 16:40:09 -0500 From: Herb Pabst Reply-To: herbie@nextearth.com X-Mailer: Mozilla 4.7C-CCK-MCD {C-UDP; EBM-APPLE} (Macintosh; I; PPC) MIME-Version: 1.0 To: pgsql-php Subject: Rows in tables... Content-Type: text/plain; charset=us-ascii; x-mac-type="54455854"; x-mac-creator="4D4F5353" Content-Transfer-Encoding: 7bit X-Archive-Number: 200102/23 X-Sequence-Number: 162 What is the easiest way to get the total number of rows in a table? I want to do a random pick from a table and need to know how many rows are in the table. Do I do a "SELECT * FROM table" and use the info from this, or will a select return all the data? This is where I'm hazy. Or does fetch_row actually return the data? Any help is appreciated, Herbie Pabst