dayang Posted May 15, 2009 Share Posted May 15, 2009 how to calculate total data in row.example i have 10 data in 1 table and i want to view the value "10" at interface. Quote Link to comment Share on other sites More sharing options...
starphp Posted May 15, 2009 Share Posted May 15, 2009 Use the count() .. SELECT COUNT(*) as count FROM YOUR_TABLE_NAME; If needed, please add WHERE clause or refer to site.. for the syntax and more details about the COUNT() Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.