$query = "SELECT COUNT(*) FROM `company`"; $result = mysql_query($query) or die(mysql_error()); $row = mysql_fetch_array($result); $totalRecs = $row['COUNT(*)']; ----- Original Message ----- From: Jer To: [email protected] Sent: Tuesday, September 19, 2006 7:04 AM Subject: [php_mysql] Re: Creating a message board...reply count
COUNT() would work. I can write the MySQL code with it no problem. But how do I print the count number. --- In [email protected], Derek Nugent <[EMAIL PROTECTED]> wrote: > > I just a newbie but I'd add a count variable and add to it for every cycle of out put (if you're using a loop for output) > > > > > ----- Original Message ---- > From: Jer <[EMAIL PROTECTED]> > To: [email protected] > Sent: Monday, September 18, 2006 9:51:48 AM > Subject: [php_mysql] Creating a message board...reply count > > I'm trying to create a message board and I want to add a reply count. The entire board is in > one table is a mbid column and a mb_parent column. When there is a reply, it writes the mbid > from the top level post to mb_parent. > > I want to get a count of how many mb_parents = mbid. > > How can I do this? > > Thank you. > > > > > [Non-text portions of this message have been removed] > [Non-text portions of this message have been removed] The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/php_mysql/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
