Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <select name="invdate" id="invdate">
- <?php
- $myServer = "LAMSSQL";
- $myUser = "sa";
- $myPass = "bevotexas";
- $myDB = "APNCDR_new";
- $dbhandle = mssql_connect($myServer, $myUser, $myPass)
- or die("cant connect");
- $Selected = mssql_Select_db($myDB, $dbhandle)
- or die("cant connect to db");
- $query = "SELECT INVDATE FROM InvoicePrint WHERE (CYCLE='30') GROUP BY INVDATE";
- $result = mssql_query($query);
- $numRows = mssql_num_rows($result);
- while( $row = mssql_fetch_array($result))
- {
- $d1 = date('m/d/Y', strtotime($row["INVDATE"]));
- echo "<option value='".$d1."'>".$d1."</option>";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement