PHP/ms SQL

Discussion in 'Databases' started by oneboxonene, Mar 20, 2004.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. oneboxonene

    oneboxonene

    I'd appreciate any sample codes (Useing "foo") illustrating SUCCESFUL php/ms sql connect&query to Discount.ASP db's. Or modification to sample below:

    <?
    $msconnect=mssql_connect("MyServer70","sa","");
    $msdb=mssql_select_db("Northwind",$msconnect);
    $msquery = "select titleofcourtesy,firstname,lastname from employees";
    $msresults= mssql_query($msquery);
    while ($row = mssql_fetch_array($msresults)) {
    echo "<li>" . $row['titleofcourtesy'] . " " . $row['firstname'] . " " . $row['lastname'] . "</li>\n";
    }
    ?>
     
    oneboxonene, Mar 20, 2004
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    see this

    http://kb.discountasp.net/article.aspx?id=10086


    quote:Originally posted by oneboxonene


    I'd appreciate any sample codes (Useing "foo") illustrating SUCCESFUL php/ms sql connect&query to Discount.ASP db's. Or modification to sample below:

    <?
    $msconnect=mssql_connect("MyServer70","sa","");
    $msdb=mssql_select_db("Northwind",$msconnect);
    $msquery = "select titleofcourtesy,firstname,lastname from employees";
    $msresults= mssql_query($msquery);
    while ($row = mssql_fetch_array($msresults)) {
    echo "<li>" . $row['titleofcourtesy'] . " " . $row['firstname'] . " " . $row['lastname'] . "</li>\n";
    }
    ?>
    </blockquote id="quote"></font id="quote">
     
    Bruce, Mar 21, 2004
    #2
  3. tsuchan

    tsuchan

    The code provided on the link is for MySQL. The poster asked about MS SQL.
     
    tsuchan, Dec 26, 2006
    #3
  4. raymondp

    raymondp

    raymondp, Dec 26, 2006
    #4
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page