mssql, PHP and field names

We've worked a lot with PHP3/MySQL with pleasure. But now I have to write a PHP3 script for an NT box with mssql server on it. Translating from the MySQL scripts works out right for the most but with MySQL I was used to use the mysql_field_name() function a lot.
mssql_field_name() doesn't exist as a function.
I've seen mssql_field_seek() and mssql_fetch_field() but don't know how to use them, also couldn't find it in the PHP3 docs.
I can't play with these functions because the NT box is not at my place, can someone help please...?
FranXAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

oubelkasCommented:
Have you solved it yet FranX? Try using mssql_field_seek() or mssql_fetch_field() after succesfully installing PHP for WinNT

J.
0
aarieCommented:
I don't know how those two functions work either, as documentation is pretty vague... However i would like to know what the solution to this problem is...

Arjan.
0
gravityCommented:
Quite why do you need to use the mysql_field() function ? I do a lot of database work using PHP and MySQL but I've never had the need to use it.
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

svsCommented:
FranX,

mssql_field_seek() and mssql_fetch_field() are desribed in http://www.php.net/manual/function.mssql-field-seek.php3 and http://www.php.net/manual/function.mssql-fetch-field.php3, respectively.  If that is not enough information, sorry; I have not used
PHP with MS SQL Server.
0
MARKIICommented:
Pls use ftp to sumit your php3 code that can be write in any text editor.
then browse from internet.

You can use this code below as ex.
<?
mysql_connect(   "localhost",   "root",   "password");

mysql_select_db(   "databasename")  or  die(   "Error  opening database");

$result  =  mysql_query(   "select  Season1,rtl1,rtl2,rtl3,Season2,rtm1,rtm2,rtm3,Season3,rth1,rth2,rth3 from  db where Hotel_Name='name'");

    while  ($row  =  mysql_fetch_row($result))  {
               echo"<center><table border=1 width=600>";
               echo"<tr><td rowspan=2><center><b><font color=#0000A0>Period for Room</font></b></center></td><td rowspan=2><center><b><font color=#0000A0>Published
      Rate<br>Single / Twin</font></b></center></td><td colspan=2>
      <center><b><font color=#0000A0>Standard Room Single / Twin</font></b></center></td></tr><tr><td>
      <center><b><font color=#0000A0>HKD</font></b></center></td><td>
      <center><b><font color=#0000A0>USD</font></b></center></td></tr>";
  echo"<tr><td><b><font face=Arial color=#000000 size=2>$row[0]</font></b></td><td><center>$row[1]</center></td><td><center>$row[2]</center></td><td><center>$row[3]</center></td></tr>";
 echo"<tr><td><b><font face=Arial color=#000000 size=2>$row[4]</font></b></td><td><center>$row[5]</center></td><td><center>$row[6]</center></td><td><center>$row[7]</center></td></tr>";
echo"<tr><td><b><font face=Arial color=#000000 size=2>$row[8]</font></b></td><td><center>$row[9]</center></td><td><center>$row[10]</center></td><td><center>$row[11]</center></td></tr>";
 echo"</table></center>";
 echo"<center><table border=1 width=600>";
 echo"<tr><td><center>NB: Prices are fully inclusive service charge and government tax</center></td></tr>";
 echo"</table></center>";
  }
?>

0
oubelkasCommented:
First of all, FranX talks about mssql, so not mysql and FranX, you might try this link :

http://phpdb.linuxbox.com

Joseph
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
FranXAuthor Commented:
Of course as you understand I've already been to http://www.php.net/manual/function.mssql-field-seek.php3, I always RTFM!

Thank's Though
0
FranXAuthor Commented:
Yep,

Good explanation on this site,
Thanx
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.