SELECT
`DATE`,
`CREW`,
`SHIFT`,
`LINE`,
`LINE_NUM`,
`PERSON_1`,
`PERSON_2`,
`PERSON_3`,
`PERSON_4`
FROM
`YourTableNameHere`
ORDER BY
`DATE`,
`SHIFT`
Note use of ` (Backticks) to get around conflict with DB reserved words. This is not endorsing the use of reserved words but demonstrate you can use them without confusing the DB. <a href="CE_CREWA_SELECT2.php?ID=<?php echo $result["DATE"] ->format("Y-m-d");?>">View/Edit</a>
which passes the date to the query, and the query it is $stmt = "SELECT * FROM CE_MANNING WHERE DATE = ? ";. This works but I want to pass date as well as SHIFT.
I don't believe that MS SQL Server supports the use of backticks.I was going on this (as it was not clear on TA's selected)
I have a table in my sql server dbMS SQL uses [ ] so
SELECT
[DATE],
[CREW],
[SHIFT],
[LINE],
[LINE_NUM],
[PERSON_1],
[PERSON_2],
[PERSON_3],
[PERSON_4]
FROM
[CE_MANNING]
ORDER BY
[DATE],
[SHIFT]
SELECT * FROM [CE_MANNING] WHERE [DATE]=? AND [SHIFT]=?
<a href="CE_CREWA_SELECT2.php?ID=<?php echo $result["DATE"] ->format("Y-m-d");?>">View/Edit</a>
To say how the script changes we need to see it but to pass the additional parameter<a href="CE_CREWA_SELECT2.php?ID=<?php echo $result["DATE"]->format("Y-m-d");?>&shift=<?php echo $result["SHIFT"];?>">View/Edit</a>
$strID = null;
if(isset($_GET["ID"]))
{
$strID = $_GET["ID"];
}
$connectionInfo = array("Database"=>$dbName, "UID"=>$userName, "PWD"=>$userPassword, "MultipleActiveResultSets"=>true);
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false ) {
die( print_r( sqlsrv_errors(), true));
}
$stmt = "SELECT * FROM TABLLE WHERE DATE = ?, AND SHIFT= ? ";
$params = array($strID);
$query = sqlsrv_query( $conn, $stmt, $params);
$result = sqlsrv_fetch_array($query, SQLSRV_FETCH_ASSOC)
?>
<?
$strID = null;
// DEFAULT RETURN
$result = array();
// GET PARAMS SAFELY
$strID = isset($_GET["ID"]) ? $_GET["ID"] : false;
$strSHIFT = isset($_GET["SHIFT"]) ? $_GET["SHIFT"] : false;
// ONLY PROCEED IF WE GOT VALID PARAMETERS
if ($strID && $strSHIFT) {
$connectionInfo = array(""=>$dbName, ""=>$userName, ""=>$userPassword, "MultipleActiveResultSets"=>true);
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false ) {
die( print_r( sqlsrv_errors(), true));
}
// SET UP QUERY WITH PARAMETERS
$stmt = "SELECT * FROM [CE_MANNING] WHERE [DATE] = ?, AND [SHIFT]= ? ";
// ADD PARAMETER VALUES
$params = array($strID, $strSHIFT);
$query = sqlsrv_query( $conn, $stmt, $params);
$result = sqlsrv_fetch_array($query, SQLSRV_FETCH_ASSOC);
}
// RETURN DATA
?>
<table width="500" border="1" id="myTable">
<tr>
<th width="91"> <div align="center">ID</div></th>
<th width="91"> <div align="center">Date</div></th>
</tr>
<?php
while($result = sqlsrv_fetch_array($query, SQLSRV_FETCH_ASSOC))
{
?>
<tr>
<td align="center" width="120px" nowrap> <div align="center"><?php echo $result["DATE"] ;?></div></td>
<td align="center" width="120px" nowrap> <?php echo $result["SHIFT"];?></td>
</tr>
<?php
}
?>
</table>
<br>
<br>
<?php
sqlsrv_close($conn);
?>
</div>
</article>
</body>
</html>