Zikula Community

• mderdem
  
  

  • Rank: Registered User
  • Registered: Oct 31, 2003
  • Last visit: Oct 21, 2009
  • Posts: 39

  Posted: Jan 02, 2007 - 03:48 AM

  Hello,
  
  I am trying to get the total number of stories in the database. I guess I could use an SQL query but first I can't really do SQL good, secondly that would probably be slow, right ?
  
  Is there an API function or another way of getting this number ?
  
  Thanks in advance,
  
  MDE

  • 
  •  
• Simon
  
  

  • Rank: Legend
  • Registered: Dec 11, 2002
  • Last visit: Oct 21, 2009
  • Posts: 11674

  Posted: Jan 02, 2007 - 04:55 AM

  You'll have to query the database. Something like
  
  

  Code

  SELECT count(*) FROM $pntables['news'];

  
  
  --
  itbegins.co.uk - Zikula Consulting
  
  birtwistle.me.uk - Personal Blog
  
  
  Please read the Support Guide

  • 
  •  
•  
•  

Users on-line

• mazdev,
• mesteele101

This list is based on users active over the last 60 minutes.