473,471 Members | 1,854 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

mssql with php record count problem

mageswar005
72 New Member
hi,
currently i worked with php and mssql,i need to count the records from mssql server.but the total count values are not worked.

1) mssql_num_rows -> not worked
2) Select count(*) as cnt from table name -> not worked

any one help me how to count the records from table

regards
mageswaran
Apr 21 '08 #1
2 2653
Markus
6,050 Recognized Expert Expert
hi,
currently i worked with php and mssql,i need to count the records from mssql server.but the total count values are not worked.

1) mssql_num_rows -> not worked
2) Select count(*) as cnt from table name -> not worked

any one help me how to count the records from table

regards
mageswaran
How about showing us the code you used?

Use code tags (refer to forum guidelines on how to do this).
Apr 21 '08 #2
ronverdonk
4,258 Recognized Expert Specialist
hi,
currently i worked with php and mssql,i need to count the records from mssql server.but the total count values are not worked.

1) mssql_num_rows -> not worked
2) Select count(*) as cnt from table name -> not worked

any one help me how to count the records from table

regards
mageswaran
I just do not believe you! Commands like that are used a zillion times a day and it doesn't work for you? There must be definitely wrong with your code. So show it here and do not forget, like markusn00b already pointed out, to use the appropriate code tags!

Ronald
Apr 21 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Oren | last post by:
Hi, I have an Access application with linked tables via ODBC to MSSQL server 2000. Having a weird problem, probably something i've done while not being aware of (kinda newbie). the last 20...
5
by: Bradley.. .. . . .. .. | last post by:
Requirement: managers can login and only see employee data for the department they manage and any sub-ordinate departments. The departments are in a table that defines a simple tree structure...
14
by: Kukurydz | last post by:
I've got such problem: My database is stored on MSSQL Server. I have to write reports for it in MSAccess. I've got a problem with creating a query which will select records from MSSQL table with...
4
by: Peter | last post by:
Hello I have 2 locations, that each has an MSSQL 2000 server. Since the locations are to far from each other and the connection is very slow. My thought was to have a database on both servers...
4
by: Peter W Johnson | last post by:
Hi guys, I have a problem with a datagrid record count. Here is the code:- <snip> Public Class frmMerchantDeposit Inherits System.Windows.Forms.Form Dim myconnection As New...
1
by: brosner | last post by:
I installed MSSQL 2000 on my desktop (running NT 2000). No problem. I created an adp and attached it to a database within MSSQL 2000, no problem. When I go into MS Access, on another PC (running...
4
by: ThePhenix | last post by:
Hi everybody, I have recently been doing a conversion for my boss for a access 2000 database (both front and backend) to a MSSQL backend. I finished the conversion today (as quite a lot of the...
3
dcharnigo
by: dcharnigo | last post by:
I am writing a purge routine for a database that I have. I select all records that have aged to a certain threshold into a temp table, now I want to remove some of these items, then in the end after...
2
Ciary
by: Ciary | last post by:
hi all, i just encountered a strange problem. on one of my php pages, i'm using a mssql database. the problem wasn't connecting buut after it i tried this: $id =...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.