printing column from table??

[rajtpd]

Hello everyone,
I know this is a little stupid question, but I am new to PHP and little help will be greatly appreciated.

I currently have a table with 2 columns with rows growing every day.

table

CustomerSiteID | CustomerName
1 ABC
2 CDE
3 DEF

and it goes on and on ....

I am trying to get all the CustomerSiteID that exsist so far to print.

I got the Query as:

$sql = "SELECT CustSiteID FROM CUSTOMERS";

$result = mssql_query( $sql )
or die ( 'Unable to execute query.' );

Now my question is how do i print the results?

P.S. I am running MSSQL 2000 on Windows 2000 server

[Anon]

Here are all the PHP functions for MS SQL server:

http://www.php.net/manual/en/ref.mssql.php

To get the results, you'd use one of the mssql_fetch_*

Diego