|
-
Apr 28th, 2012, 11:33 PM
#2
Re: how to display select count result in listview
Hi, Welcome to the forums..
Next time when you post your code fragments, enclose it like this:
[CODE]your code goes here[/CODE]
Regarding your question, maybe you could try it like this:
Code:
...status, COUNT(*) AS cnt from mytable...
Now the resultset would have an additional field named "cnt" which would contain the count.
If my post was helpful to you, then express your gratitude using Rate this Post. 
And if your problem is SOLVED, then please Mark the Thread as RESOLVED (see it in action - video)
My system: AMD FX 6100, Gigabyte Motherboard, 8 GB Crossair Vengance, Cooler Master 450W Thunder PSU, 1.4 TB HDD, 18.5" TFT(Wide), Antec V1 Cabinet
Social Group: VBForums - Developers from IndiaSkills: PHP, MySQL, jQuery, VB.Net, Photoshop, CodeIgniter, Bootstrap,...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote