Posting to MSSQL based on two criteria.

[Butterbean]

This is posting to any row in mssql that has a matching 'start_date'.  I would like it to post rows where start_date = '$start_date' and it also matches the 'meter_id' .  It should perform this check of both parameters before posting to mssql. 

<?php
$session_id = $_SESSION['id'];
$comm_id = $_GET['meter_id'];
$start_date = $_GET['start_date'];
$payment_date = $_POST['payment_date'];
$amount_paid = $_POST['amount_paid'];
$check_number = $_POST['check_number'];

$sql = "UPDATE [radiogates].[dbo].[ops_invoice_history] SET payment_date = '$payment_date', amount_paid = '$amount_paid', check_number = '$check_number' where start_date = '$start_date'";

$query = sqlsrv_query($conn, $sql);

Thank you for any help.

[Butterbean]

thought this would work but did not.

$sql = "UPDATE [radiogates].[dbo].[ops_invoice_history] SET payment_date = '$payment_date', amount_paid = '$amount_paid', check_number = '$check_number' where start_date = '$start_date'& meter_id = '$meter_id' ";

[CroNiX]

Are you using $_POST or $_GET? Because in your first lines of code you are using both, which is odd.

 

Regarding your query, you should use double ampersands (&&) or better to just use "AND" for the logical operator. I don't believe a single & means anything.

[Butterbean]

we are getting the start date and meter id from the db to authenticate the customer, then we are subsequently posting data back to the server.

[Butterbean]

Got it!  Messed my AND up.  That resolved the issue..  Thanks a million!