Re: edit profile php
Posted: Wed Jul 01, 2015 10:12 am
No. You're going to need four separate queries; one to update users and one for each row of renewal that needs updating. The where clause is going to be different for each.
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
$query = "Update users SET name='$name', email='$email', address1='$address1', address2='$address2', town='$town', county='$county', postcode='$postcode', telnumber='$telnumber', mobnumber='$mobnumber', model='$model', numplate='$numplate' WHERE id='$id';";
$sql = "UPDATE renewal SET id='$id', renewal_date='$insurance' WHERE item_id=1 LIMIT 1;";
$sql = "UPDATE renewal SET id='$id', renewal_date='$mot' WHERE item_id=2 LIMIT 1;";Code: Select all
$sql = "UPDATE renewal SET id='$id', renewal_date='$insurance' WHERE item_id=1 LIMIT 1;";
$sql = "UPDATE renewal SET id='$id', renewal_date='$mot' WHERE item_id=2 LIMIT 1;";
$sql = "UPDATE renewal SET id='$id', renewal_date='$tax' WHERE item_id=3 LIMIT 1;";Have you checked the value of $tax before executing the query? Does it contain a value? Is it formatted correctly?it leaves the tax date empty
Code: Select all
$sql2 = "UPDATE renewal SET renewal_date='$insurance' WHERE item_id=1 LIMIT 1;";
$query2 = mysqli_query($db, $sql2) or die (mysqli_error($db));
$sql3 = "UPDATE renewal SET renewal_date='$mot' WHERE item_id=2 LIMIT 1;";
$query3 = mysqli_query($db, $sql3) or die (mysqli_error($db));
$sql4 = "UPDATE renewal SET renewal_date='$tax' WHERE item_id=3 LIMIT 1;";
$query4 = mysqli_query($db, $sql4) or die (mysqli_error($db));