forum.vdsworld.com Forum Index forum.vdsworld.com
Visit VDSWORLD.com
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 


vdsdb - count rows?

 
Post new topic   Reply to topic    forum.vdsworld.com Forum Index -> General Help
View previous topic :: View next topic  
Author Message
Scheben
Newbie


Joined: 09 Apr 2002
Posts: 9
Location: Stuttgart,Germany
PostPosted: Wed Jan 29, 2003 12:36 pm    Post subject: vdsdb - count rows? Reply with quote
Hallo,

does somebody know the correct syntax to count the rows in a table via vdsdbb.dll?

thanks for your tips Smile
chris
Back to top
View user's profile Send private message
Tommy
Admin Team


Joined: 16 Nov 2002
Posts: 746
Location: The Netherlands
PostPosted: Thu Jan 30, 2003 7:28 pm    Post subject: Reply with quote
Hi Chris,

You should be able to use something similar to:

Code:

  db query,"SELECT COUNT(*) AS rows FROM vds_files;"
  db fetchrow
  info @db(get,rows)

Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    forum.vdsworld.com Forum Index -> General Help All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum

Twitter@vdsworld       RSS

Powered by phpBB © 2001, 2005 phpBB Group